What Kind of a TBS is this ???
- G
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
-- ----------------------------------------------------------- http://iyertalks.blogspot.com/