Oracle
1Z0-063 · Question #89
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…
The correct answer is D. Take the temporary tablespace offline, recover the missing temp file, and then bring the E. Create a new temporary tablespace and assign it as the default to the user. See the full explanation below for the reasoning.
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?
Options
- ADrop the tenpOi.dbf file, and then re-create the temp file.
- BAdd a new temp file to the temporary tablespace and drop the tempOi.dbf file.
- CShut down the database instance, start up the database instance in mount state, create a new
- DTake the temporary tablespace offline, recover the missing temp file, and then bring the
- ECreate a new temporary tablespace and assign it as the default to the user.
How the community answered
(43 responses)- A5% (2)
- B19% (8)
- C7% (3)
- D70% (30)
Community Discussion
No community discussion yet for this question.