1.startup--啟動數(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)臨時表空間 3.alter database default; temporary tablespace; temp2;;--改變?nèi)笔∨R時表空間 為剛剛創(chuàng)建的新臨時表空間temp24.drop tablespace temp including contents and datafiles;--刪除原來臨時表空間5.create temporary tablespace; TEMP TEMPFILE '/home2/oracle/oradata/sysmon/temp01.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT; 640K MAXSIZE UNLIMITED;--重新創(chuàng)建臨時表空間6.alter database default; temporary tablespace; temp;;--重置缺省臨時表空間為新建的temp表空間7.drop tablespace temp2 including contents and datafiles;--刪除中轉(zhuǎn)用臨時表空間8.alter user roll temporary tablespace; temp;--重新指定用戶表空間為重建的臨時表空間