RE: Is is safe to drop old temp space?

From: Mercadante, Thomas F (LABOR) <>
Date: Fri, 7 Mar 2008 11:41:12 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF01B0C183@EXCNYSM0A1AJ.nysemail.nyenet>


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.


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

[] On Behalf Of
Sent: Friday, March 07, 2008 11:28 AM
Subject: Is is safe to drop old temp space?


I am running oracle 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


-- Received on Fri Mar 07 2008 - 10:41:12 CST

Original text of this message