6 Replies Latest reply: Feb 8, 2010 12:51 AM by Ora_83 RSS

    change next extent size of the table in DMT

      DMT. Oracle 9i.
      Is there way to change the next extent size of the table?
      There are lots of freechunks in dba_free_space. I want them to be used.

      SQL> select TABLE_NAME,NEXT_EXTENT from dba_tables where table_name='MOTR';
      TABLE_NAME                     NEXT_EXTENT
      ------------------------------ -----------
      MOTR                          20971520
      SQL> select TABLESPACE_NAME,NEXT_EXTENT from dba_tablespaces where TABLESPACE_NAME='RACT_DATA';
      TABLESPACE_NAME                NEXT_EXTENT
      ------------------------------ -----------
      RACT_DATA                        20480