SQL> create tablespace tbs_roger datafile '/oracle/tbs_roger.dbf' size 1m autoextend on next 2m;

Tablespace created.

SQL> r
1* select tablespace_name,file_name,increment_by,increment_by*8/1024 as increment_mb from dba_data_files where tablespace_name='TBS_ROGER'

TABLESPACE_NAME FILE_NAME INCREMENT_BY INCREMENT_MB
------------------------------ ------------------------------ ------------ ------------
TBS_ROGER /oracle/tbs_roger.dbf 256 2

SQL> alter database datafile '/oracle/tbs_roger.dbf' autoextend on next 4m;

Database altered.

---变更数据文件next后
SQL> select tablespace_name,file_name,increment_by,increment_by*8/1024 as increment_mb from dba_data_files where tablespace_name='TBS_ROGER';

TABLESPACE_NAME FILE_NAME INCREMENT_BY INCREMENT_MB
------------------------------ ------------------------------ ------------ ------------
TBS_ROGER /oracle/tbs_roger.dbf 512 4

小结：autoextend,next,maxsize针对目标是datafile,是指数据文件用完后，是否自动扩展数据文件的大小；之后每次扩展多大尺寸;最大扩展到多大就终止了

ITPub博客

create tablespace之autoextend on和next及maxsize

最新文章