扩展表空间

1.查看表空间使用情况

select
a.tablespace_name "tablespace",
trunc(a.total) "allocated(M)",
ceil((1-b.free/a.total)*100) "Usage %",
trunc(b.free) " free space(M)"
 from
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 total from dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 free from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name order by 3 desc

2.扩展表空间，检查表空间文件数及文件位置

select  file_name,tablespace_name  from dba_data_files where tablespace_name ='MSCD'  

3.添加数据文件

alter tablespace MSCD add datafile '/u02/TEST/testdata/mscd04.dbf' size 1000m;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/209689/viewspace-584340/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/209689/viewspace-584340/