1.startup--啟動數據庫2.create temporary tablespace; TEMP2 TEMPFILE '/home2/Oracle/oradata/sysmon/temp02.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT; 640K MAXSIZE UNLIMITED;--創建中轉臨時表空間 3.alter database default; temporary tablespace; temp2;;--改變缺省臨時表空間 為剛剛創建的新臨時表空間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;--重新創建臨時表空間6.alter database default; temporary tablespace; temp;;--重置缺省臨時表空間為新建的temp表空間7.drop tablespace temp2 including contents and datafiles;--刪除中轉用臨時表空間8.alter user roll temporary tablespace; temp;--重新指定用戶表空間為重建的臨時表空間