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

    change next extent size of the table in DMT

    Ora_83
      Hello.
      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