a question about Tom's book "Expert one-on-one Oracle" (about Data Block)

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: 10 Dec 2005 06:05:23 -0800
Message-ID: <1134223523.732649.164930@f14g2000cwb.googlegroups.com>

hi everyone:

i have a question about Tom's new book "Expert one-on-one Oracle". In Chapter 2, when talk about data files in Oracle system, tom said that the data block structure have a "block header", it has a table directory which " The table directory, if present, contains information about the tables that store rows in this block (data from more than one table may be stored on the same block). "

My question is, the data block belong to a extent which belong to a table/index segment, finally segments belong to a tablespace. How can a block can contain more than one table's rows?

anyone have answer? can give me some advice?

Thank you.

Havel Received on Sat Dec 10 2005 - 08:05:23 CST