Oracle
1Z0-067 · Question #81
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 B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file. 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
(31 responses)- A6% (2)
- B77% (24)
- C13% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.