Re: DATA BLOCK

Luis Nobre doodled thusly:

>Can anyone please explain me how a block may contain rows from more than one table?
>

IIRC, the following is possible:

• clustered tables. These used to be in <= 8.0. I believe they are still available in 8i if not 9i?

I think nested tables can also physically share the same block, but don't quote me on that: only used them once and it was such a small data set anyway it didn't matter what the physical allocation would be, so I didn't bother checking...

Jonathan Lewis's book dives into nested tables in great detail. Worth a read in any case!

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Feb 21 2002 - 07:07:21 CST