martes, 13 de junio de 2017

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

No hay comentarios: