Re: DATA BLOCK

Andrew Mobbs doodled thusly:

>
>Hm... I've never used nested tables in anger, but the Storage Internals
>course notes say "Nested tables are stored in a separate table called the
>store table", they don't mention in-line, as they do for VARRAY and LOBs.
>

VARRAYs! That's the ones I couldn't remember the name of last week. Thanks, you just solved a minor problem I had for a report!

Coming back to this. IIRC, VARRAYS are in-lined if <4K and fitting the block size. If not, then ORACLE does a "LOB" on them and puts them on their own segment, internally-generated names/index names and all. So truly, they aren't multiple tables in the same block. Clustering would still be the most obvious example?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Feb 22 2002 - 02:18:44 CST