ORA-01691
STATUS = -6372

sqlplus
@q_tbsFREE

新增擴容
alter tablespace dbs1 add datafile '/u2/oradb/oradata/topprod/dbs1-07.dbf' size 8192M;

空間的檔案位置查詢
select t1.name,t2.name  
from v$tablespace t1,v$datafile t2 
where t1.ts# = t2.ts#;

select tablespace_name, file_id, file_name,
round(bytes/(1024*1024),0) total_space
from dba_data_files
order by tablespace_name

採砊記錄
查詢各oracle user回收桶,空間使用率
sqlplus sys as sysdba

select owner,count(*),SUM(space)*8/1024/1024 GB from dba_recyclebin group by owner;

清除所有回收桶的資料
sqlplus sys as sysdba
purge dba_recyclebin