ALTER TABLE INITRANS

SQL> CREATE TABLE test (id NUMBER);

Table created.

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST';

INI_TRANS  MAX_TRANS
---------- ----------
         1        255

SQL> ALTER TABLE TEST INITRANS 5 MAXTRANS 255 ;

Table altered.

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST' ;

INI_TRANS  MAX_TRANS
---------- ----------
         5        255

This statement alters the default attributes of local partitioned index SALES_IX3. New partitions added in the future will use 5 initial transaction entries and an incremental extent of 100K:

 

ALTER INDEX sales_ix3 MODIFY DEFAULT ATTRIBUTES INITRANS 5 STORAGE ( NEXT 100K );