In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level.
How would you recover the tablespace?
A. flash back the database
B. perform point-in-time recovery
C. perform a full database recovery
D. drop and re-create the tablespace
E. use Recovery Manager (RMAN) to recover the database
Answer: D
A temporary tablespace contains transient data that persists only for the duration of the session. Temporary tablespaces can improve the concurrency of multiple sort operations that do not fit in memory and can improve the efficiency of space management operations during sorts.
Temporary tablespaces are used to store the following:
-
Intermediate sort results
-
Temporary tables and temporary indexes
-
Temporary LOBs
-
Temporary B-trees
A sort segment is created by the first statement after startup that uses the temporary tablespace for sorting, and is released only at shutdown.