RE: Is is safe to drop old temp space?
Date: Fri, 7 Mar 2008 11:41:12 -0500
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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, March 07, 2008 11:28 AM
Subject: Is is safe to drop old temp space?
I am running oracle 220.127.116.11. I just finished recreating a temp
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?
http://www.freelists.org/webpage/oracle-l Received on Fri Mar 07 2008 - 10:41:12 CST