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.
D&E
AE
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.
BE