Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DATA BLOCK

Re: DATA BLOCK

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 21 Feb 2002 20:56:49 +0000
Message-ID: <3C755F11.5C9D@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US