Re: DATA BLOCK

From: Yong Huang <yong321_at_yahoo.com>
Date: 20 Feb 2002 21:15:50 -0800
Message-ID: <b3cb12d6.0202202115.6fa0c705@posting.google.com>

J. Lewis is the authority on this. But I suspect a nested table is not really a table, physically. Two cluster tables can use the same data block.

Also, Oracle manual contrasts a heap (regular) table with IOT. Look at ORGANIZATION section of SQL reference to CREATE TABLE.

Yong Huang
yong321_at_yahoo.com

damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C7436B6.3593F097_at_ci.seattle.wa.us>...
> Only with a nested table. With heap tables (regular tables) it can not be.
>
> Daniel Morgan
>
>
>
> Luis Nobre wrote:
>
> > Can anyone please explain me how a block may contain rows from more than one table?
> >
> > Thanks!!
> > LCLN
Received on Wed Feb 20 2002 - 23:15:50 CST