改变表空间的存储设置

alter tablespace 表空间名
minimum extent 正整数[k|m]
[default 存储子句]
例如:
SQL> alter tablespace longshen minimum extent 100k;

SQL> alter tablespace longshen default storage (initial 100k next 100k maxextents 200);

SQL> select tablespace_name,initial_extent,next_extent,max_extents,pct_increase,min_extlen from dba_tablespaces where tablespace_name like 'LONGSHEN';

TABLESPACE_NAME                INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
------------------------------ -------------- ----------- -----------
PCT_INCREASE MIN_EXTLEN
------------ ----------
LONGSHEN                              1048576     1048576  2147483645
           0    1048576

 

整理自 何明《Oracle DBA基础培训教程》