Home » RDBMS Server » Server Administration » can data from more than one table be stored in a oracle block
can data from more than one table be stored in a oracle block [message #49709] Tue, 05 February 2002 18:16 Go to next message
Sankar
Messages: 10
Registered: February 2002
Junior Member
can data from more than one table be stored in a oracle block ?

Report message to a moderator

NO it can not [message #49718 is a reply to message #49709] Wed, 06 February 2002 03:43 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
Because one segment extent is always based on one or several oracle blocks it is not possible that several tables are using the same block. An exception to this are clustered tables.

HTH
Mike

Report message to a moderator

Previous Topic: Re: Free OCP Papers
Next Topic: Restricted access
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:59:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.