#新增表空间文件
alter database datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\EXDBDATA5.DBF' autoextend on next 200m maxsize 300000m;
#重新设置表空间大小
alter database datafile '表空间位置' resize 新的尺寸
#设置表空间自动增长
alter database datafile '数据文件位置' autoextend on next 自动扩展大小 maxsize 最大扩展大小
#设置表空间无限自动增长
ALTER DATABASE DATAFILE 'C:\TABLESPACE\JGCL2016_10.DBF' AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED;
#查看表空间使用情况
select a.tablespace_name,
a.bytes / 1024 / 1024 "sum MB",
(a.bytes - b.bytes) / 1024 / 1024 "used MB",
b.bytes / 1024 / 1024 "free MB",
round(((a.bytes - b.bytes) / a.bytes) * 100, 2) "used%"
from (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes, max(bytes) largest
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name
order by ((a.bytes - b.bytes) / a.bytes) desc;