A user issues a query on thesales table and receives the following error:ERROR at line 1:ORA-01565: error in identifying
Posted: Sun Jun 11, 2023 3:54 pm
A user issues a query on thesales 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 statusWhich 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.
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.