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