1. startup -- start the database2. Create temporary tablespace temp2 tempfile '/home2/Oracle/oradata/sysmon/temp02.dbf' size 512 M reuse autoextend on next 640 K maxsize unlimited; -- create temporary tablespace for transit
3. Alter database default temporary tablespace temp2; -- change the default temporary tablespace to the newly created temporary tablespace temp2
4. Drop tablespace temp including contents and datafiles; -- delete the original temporary tablespace
5. create temporary tablespace temp tempfile '/home2/Oracle/oradata/sysmon/temp01.dbf' size 512 M reuse autoextend on next 640 K maxsize unlimited; -- recreate a temporary tablespace
6. Alter database default temporary tablespace temp; -- reset the default temporary tablespace to the new temp tablespace
7. Drop tablespace temp2 including contents and datafiles; -- delete temporary tablespace for transit
8. Alter user roll temporary tablespace temp; -- specify the user tablespace as the temporary tablespace for reconstruction.