Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATA BLOCK
Nuno Souto wrote:
>
> 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
They're still there in 9i - probably to handle the fact the the catalog still uses them massively :-)
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Feb 21 2002 - 14:56:49 CST