Is this applicable for undo tablespace as well ? -- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise Applications Rice University (713) 348 6365 Mercadante, Thomas F (LABOR) wrote:
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of genegurevich@xxxxxxxxxxxx Sent: Friday, March 07, 2008 11:28 AM To: oracle-l@xxxxxxxxxxxxx Subject: Is is safe to drop old temp space? Hello: I am running oracle 184.108.40.206. 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 !DSPAM:59,47d17243156591348146124!