Temporary Tablespace Management

Concepts:- Temporary File Concepts and Scenarios.

Temporary File Recovery

Automatic Temporary File Recovery

If any temporary file is lost then it can be automatically recovered at time of database startup.

Manually Recover Temp File                                     

We can manually recovery the temporary file.

SQL> alter tablespace temp add tempfile ‘+data(tempfile)’ size 100M;

SQL> Alter tablespace temp drop tempfile ‘+data/orcl/tempfile/temporary.12364.266.tmp’;