Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can a block in Oracle contain rows/data from multiple tables?

CSM.DBAJul 1 2013 — edited Jul 2 2013

Hi during my discussion with one of the DBAs, a point came up i.e. A block shouldn't have rows from multiple tables...

Is that true? I read in one of the OTN thread (i don't exactly remember the thread name) that a block can have data from multiple tables. If it doesn't have, what's the table directory in block signifies?

Please share your views.

Thanks,

CSM

This post has been answered by CSM.DBA on Jul 2 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2013
Added on Jul 1 2013
9 comments
1,145 views