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;
网友评论