Is is safe to drop old temp space?

From: <genegurevich_at_discover.com>
Date: Fri, 7 Mar 2008 10:27:32 -0600
Message-ID: <OFED59533A.2E6BE354-ON86257405.005A3A55-86257405.005A6ABD@discover.com>


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
Received on Fri Mar 07 2008 - 10:27:32 CST

Original text of this message