Table partion storage

From: Alessandro Vercelli <alever_at_libero.it>
Date: Wed, 20 Sep 2006 14:17:03 +0200
Message-Id: <J5W4SF$D5A815A946FCCE29219E3E392BCE4F41@libero.it>

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 Received on Wed Sep 20 2006 - 07:17:03 CDT