DBA_TAB_PARTITIONS.PCT_INCREASE/NEXT_EXTENT null after a SPLIT PARTITION

From: Spendius <spendius_at_muchomail.com>
Date: 13 Oct 2006 05:30:01 -0700
Message-ID: <1160742601.669129.119620@m73g2000cwd.googlegroups.com>

Hi,
(v. 10.2.0.2)

I did an
ALTER TABLE stuff
SPLIT PARTITION X_20060201
at (TO_DATE('01-02-2004', 'DD-MM-YYYY')) into (

partition x_20040201
storage (initial 10485760 next 10485760 minextents 1

             maxextents 2147483645 pctincrease 0)     tablespace x_20040201_d,
    partition x_20060201
    storage (initial 10485760 next 10485760 minextents 1

maxextents 2147483645 pctincrease 0) tablespace x_20060201_d
)

Now here is what I find in the DBA_TAB_PARTITIONS dictionary: D:\> select pct_increase ,next_extent from dba_tab_partitions 2 where table_name='STUFF' and partition_name='X_20040201';

PCT_INCREASE NEXT_EXTENT
------------ -----------

These values are null (but not for the other pre-existing partitions where I read 0 and10485760): anyone's already noticed anything similar ? Any explanation ?

Thanks. Received on Fri Oct 13 2006 - 07:30:01 CDT