Oracle
1Z0-067 · Question #235
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the…
The correct answer is A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the. See the full explanation below for the reasoning.
Question
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error?
Options
- AAdd a new tempfile to the user's temporary tablespace and drop the tempfile that produced the
- BShut down the database instance, restore the temp01.tmp file from the backup, and then restart
- CAllow the database to continue running, drop the temp01.tmp temporary file, and then re-create it
- DTake the temporary tablespace offline, recover the missing tempfile by applying redo logs, and
How the community answered
(32 responses)- A75% (24)
- B13% (4)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.