Re: Table Partitioning Question

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Fri, 16 Mar 2007 01:40:02 GMT
Message-ID: <SzmKh.8928$FG1.2600@newssvr27.news.prodigy.net>

<sybrandb_at_gmail.com> wrote in message
news:ttljv2hf336tgptuisdc6k49e7i8tf6tt8_at_4ax.com...
> 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

Thank you. Received on Thu Mar 15 2007 - 20:40:02 CDT