Database Administration (MOSC)

MOSC Banner

Delete a temp file

edited Oct 5, 2009 5:00AM in Database Administration (MOSC) 6 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center