Code: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




Reply With Quote