Oracle表空间不设定限制

1、查看各个表空间状态
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files;

2、表空间无限大
alter database DATAFILE ‘/u01/oradata/xe/users01.dbf’ autoextend on maxsize unlimited;

3、建表空间、表
SQL> create tablespace app datafile ‘/u01/oradata/xe/app.dbf’ size 1M autoextend on
next 512K maxsize unlimited logging extent management local segment space manage
ment auto;