oracle数据库添加表空间

表空间使用情况查询

## 查看状态是否正常
select tablespace_name,status from dba_tablespaces;

## 查看数据文件情况
select c.tablespace_name,d.datafile_sum,d.datafile_sum*32 as max_size ,total as now_size,(d.datafile_sum*32)-total as free_size,total/(d.datafile_sum*32)*100 as "used%" from 
(select tablespace_name, sum(bytes)/1024/1024/1024 as total from dba_data_files group by tablespace_name) c left join 
(select b.name as tablespace_name,count(a.name) as datafile_sum from v$datafile a left join v$tablespace b on a.ts#=b.ts# group by b.name ) d
on c.tablespace_name=d.tablespace_name
order by max_size desc;

增加表空间

alter tablespace table_name add datafile size 10G;

ALTER TABLESPACE table_name ADD DATAFILE SIZE 500M autoextend on maxsize unlimited;

alter tablespace table_name add datafile size 500M autoextend on next 1024M maxsize unlimited; 

ALTER TABLESPACE table_name add DATAFILE '+DATA' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;