1.查看剩余表空间。
select df.tablespace_name "表空间名",
df.bytes/(1024*1024*1024) "表空间总大小(G)",(df.bytes-sum(fs.bytes))/(1024*1024*1024) "已使用表空间大小(G)",
sum(fs.bytes)/(1024*1024*1024) "剩余空间大小(G)",
round(sum(fs.bytes)*100/df.bytes,3)||'%' "空闲比(%)",
round((df.bytes-sum(fs.bytes))*100/df.bytes,3)||'%' "使用比(%)"
from dba_free_space fs right join
(select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) df on fs.tablespace_name = df.tablespace_name
--where fs.tablespace_name = df.tablespace_name /*and fs.tablespace_name like'PM%' */
group by df.tablespace_name,df.bytes
order by df.tablespace_name;
--alter tablespace PMTBS add datafile '+NOSS_DG1/oradata/nossdb/pmtbs04.dbf' size 31g; (7月2日)
-- alter table TMR4GCELL_PLRULQCISINRUL drop partition D20150708;
2.查看磁盘的文件路径:
select tablespace_name,file_name,bytes/1024/1024 filesz from dba_data_files
/*where tablespace_name like 'UIA%'*/
order by tablespace_name,file_name;
3.扩展磁盘大小
alter database datafile 'D:\ORCL193_WPMTBS_DATAFILE\WPMTBS01.DBF' resize 25G;