Oracle error

DMS-E-GENERAL, A general exception has occurred during operation 'asynchronous open'.

ORA-00372: file 83 cannot be modified at this time

ORA-01110: data file 83: '/db05/I/.TEMP_05dbf'

Incorrect spelling of the temp file. HOw to fix this?
LVL 5
shankshankAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Create a new TEMPORARY tablespace, set it as the 'default', then just drop the incorrect one.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.