Oracle
1Z0-034 · Question #8
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 I:
ORA-0I565: 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
(28 responses)- A75% (21)
- B7% (2)
- C4% (1)
- D14% (4)
Community Discussion
No community discussion yet for this question.