摘要: 清空臨時(shí)表空間
1.startup --啟動(dòng)數(shù)據(jù)庫
2.create temporary tablespace TEMP2 TEMPFILE '/home2/oracle/oradata/sysmon/temp02.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; --創(chuàng)建中轉(zhuǎn)臨時(shí)表空間
3.alter database default temporary tablespace temp2;--改變?nèi)笔∨R時(shí)表空間 為剛剛創(chuàng)建的新臨時(shí)表空間temp2
4.drop tablespace temp including contents and datafiles;--刪除原來臨時(shí)表空間
5.create temporary tablespace TEMP TEMPFILE '/home2/oracle/oradata/sysmon/temp01.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K
閱讀全文