Delete a temp file
I tried to delete my temp file to see how can I recover it… for test
purpose.
I couldn’t delete the tempfile, I got a msg that it’s in
use.
N.B: that in DBA II the lab_04_02.sh remove the tempfile from the temp tablespace and they mention that while checking the Initialization parameters
we should get an error regarding the missing temp01.dbf
To accomplish that, I tried to shutdown the database and delete that tempfile. After restarting the
DB I was created automatically so I couldn’t establish my test.
How could I delete or rename the tempfile while the database is up? Is that possible?
N.B: that in DBA II the lab_04_02.sh remove the tempfile from the temp tablespace and they mention that while checking the Initialization parameters
we should get an error regarding the missing temp01.dbf
To accomplish that, I tried to shutdown the database and delete that tempfile. After restarting the
DB I was created automatically so I couldn’t establish my test.
How could I delete or rename the tempfile while the database is up? Is that possible?
0