Prev Question
Next Question

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u0l/app/oracle/oradata/ORCL/temp01.dbf’
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

A. Drop the tenpOi.dbf file, and then re-create the temp file.

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

E. Create a new temporary tablespace and assign it as the default to the user.

Explanation:

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *