This discussion is archived
6 Replies Latest reply: Feb 7, 2010 10:51 PM by Ora_83 RSS

change next extent size of the table in DMT

Ora_83 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points