RE: Is is safe to drop old temp space?

Gene,

If it is still in use, you will not be able to drop it. You will get an ORA error message.
So it is safe to try.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, March 07, 2008 11:28 AM
To: oracle-l_at_freelists.org
Subject: Is is safe to drop old temp space?

Hello:

I am running oracle 9.2.0.8. I just finished recreating a temp tablespace.
I have created a new tablespace
and then issued alter database default tablespace temp02 command.

I think it is safe now to drop my old tablespace. I checked that all users have temporary TS set to TEMP02.
Do I need to check anything else before removing my old temp TS?

thank you

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 07 2008 - 10:41:12 CST