Your database is using a default temporary tablespace that contains the temp01.tmp temporary
file. All the users on the database use the default temporary tablespace. A user issues a query on
the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file ‘/u01/app/oracle/oradata/TEST/temp01.tmp’
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?
A.
Add a new tempfile to the user’s temporary tablespace and drop the tempfile that produced the
error.
B.
Shut down the database instance, restore the temp01.tmp file from the backup, and then restart
the database.
C.
Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create
it with new tempfiles.
D.
Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and
then bring the temporary tablespace online.