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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2013

Added on Jul 1 2013

#general-database-discussions

9 comments

1,148 views