Re: Table Partitioning Question

On Thu, 15 Mar 2007 23:18:30 GMT, "Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote:

>If a have a table partitioned into two partitions and have a storage clause
>at the table level allocating the size in the storage clause to 500k does
>that mean that the two partitions share the 500k or that each of the two
>partitions is 500k?
>
>This is probably a very simple and clear question but the more I read up on
>this to try to clear this up in my mind the more confused I get.
>
>Thanks.
>

Non-partitioned tables
table -> segment -> extents

Partitioned tables
table -> partitions -> segments -> extents

where -> is 1:m

Each of the two partitions is 500k.

--
Sybrand Bakker
Senior Oracle DBA