orcl表空间操作

1--增加表空间语句

alter tablespace issp_rygk add datafile 'data/orcl/datafile/issp_rygk07.dbf' size 2048M autoextend off;

2--查看表空间剩余

select tablespace_name,count(1) as extends,round(SUM(bytes)/1024/1024,2) as mb,SUM(blocks) as blocks from dba_free_space where tablespace_name like 'issp%' group by tablespace_name order by tablespace_name;

3--查看表空间是否这只自动增长

select file_name,tablespace_name,autoextensible from dba_data_files;

4--设置表空间自动增长(每次增长2g空间)

alter database datafile '+DATA/orcl/datafile/issp_wifiinfo1.dbf' autoextend on next 2048M;