What is the proper procedure to recover a lost tempfile?
A.
Restore the backup copy of the tempfile from the backup media.
B.
Re-create the tempfile with the create tempfile command.
C.
Copy an existing tempfile from another database.
D.
Re-create the tempfile with the create tablespace command.
E.
Re-create the tempfile with the alter tablespace command.
Explanation:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE <new file name>;
ALTER TABLESPACE <tablespace_name> TEMPFILE <old_file_name> OFFLINE;
ALTER TABLESPACE <tablespace_name> TEMPFILE <> ONLINE;