1.startup - Start the database 2.create temporary tablespace TEMP2 TEMPFILE '/home2/oracle/oradata/sysmon/temp02.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; - create a temporary table space transit 3.alter database default temporary tablespace temp2; - change the default temporary table space for the new temporary table space temp24.drop tablespace temp including contents and datafiles just created; - delete the original temporary table space 5.create temporary tablespace TEMP TEMPFILE '/ home2 / oracle / ORADATA / SYSMON / TEMP01.DBF 'SIZE 512M Reuse Autoextend On Next 640k MaxSize Unlimited; - Recreate Temporal Temples 6.alter Database Default Temporary TableSpace Temp; .drop tablespace Temp2 include, delete, transfer, temporary table space 8.alter User roll temptorry tablespace temp; - Re-specify the temporary table space of the user table space
