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 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.
Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

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

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

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

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



Leave a Reply 2

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