create tablespace之autoextend on和next及maxsize

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博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-764673/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-764673/