Re: Table partion storage

What Kind of a TBS is this ???

• G

On 9/20/06, Alessandro Vercelli <alever_at_libero.it> wrote:
>
> Hi all,
> I needed to change storage parameters for a table partion:
>
> SQL> select table_name,partition_name,INITIAL_EXTENT,NEXT_EXTENT,
> 2 PCT_INCREASE from user_tab_partitions where
> 3 partition_name='TEST_PART_01';
>
> TABLE_NAME PARTITION_NAME INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE
> -------------- --------------- -------------- ----------- ------------
> TABLE_01 TEST_PART_01 1048576 1048576 0
>
>
> SQL> alter table TABLE_01 drop partition TEST_PART_01;
>
> Table altered.
>
> SQL> ALTER TABLE TABLE_01 ADD PARTITION TEST_PART_01 values ('TEST')
> 2 tablespace TEST_TBS storage (INITIAL 100M NEXT 100M PCTINCREASE 0);
>
> Table altered.
>
> SQL> select table_name,partition_name,INITIAL_EXTENT,NEXT_EXTENT,
> 2 PCT_INCREASE from user_tab_partitions where
> 3 partition_name='TEST_PART_01';
>
>
> TABLE_NAME PARTITION_NAME INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE
> -------------- --------------- -------------- ----------- ------------
> TABLE_01 TEST_PART_01 104857600 1048576 0
>
>
> Can you help me to understand why NEX_EXTENT did not change?
>
> Thanks,
>
> Alessandro
>
>
> ------------------------------------------------------
> Tutti i libri che vuoi, li trovi su BOL. Ordini on line e paghi alla
> consegna.
> http://click.libero.it/bol
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
-----------------------------------------------------------
http://iyertalks.blogspot.com/

--
http://www.freelists.org/webpage/oracle-l