Table partion storage
- From: "Alessandro Vercelli" <alever@xxxxxxxxx>
- To: "Oracle Freelists\.org" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 20 Sep 2006 14:17:03 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
