（699）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 tablspace.

A user issues a query on the ORDERS table and receives the following error:

ERROR at line 1:

ORA-01565: 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.

答案：（C）

解析：

临时表空间的临时文件损坏，解决办法就是，增加一个新的临时文件，把老的给删除就行了，先删除，再重建也行。

临时文件的损坏不会影响数据库的运行，也不要备份和恢复

ITPub博客

Oracle 11G OCP 1Z0-053 699