Which two actions would you take to recover the tempora…

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 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.



Leave a Reply 4

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


WAS

WAS

BE
A wrong because considering that theres only one tempfile, the tablespace couldnt be without tempfile.

D wrong because theres no way to recover temp file.