Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the

Post by answerhappygod »

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 statusWhat 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply