Re: Storage Structures clarification

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Mar 1999 20:44:51 +0100
Message-ID: <36F69DB3.BE7BBC88@sybrandb.demon.nl>

Hi Joe,

The answer is no. Each table has it's own table directory. Once a block is allocated to a table, it can't be allocated to any other segment, ie the smallest unit of allocation is a block.

Hth,

Sybrand Bakker, Oracle DBA

Joe gulla wrote:

> I'm slightly confused . If , out of manual ,"each table's data is
> store in it's own segment " sounds singular to me. Segment made up of
> extents, extents made up
> of blocks.
> The block header contains "table directory" which contain's
> information about
> tables having rows in the block. This sounds like more than one table
> can
> have rows in a block.
> Is this correct ?
> Joe Gulla

Received on Mon Mar 22 1999 - 13:44:51 CST