RE: Is is safe to drop old temp space?

There are Metalink documents describing how to recreate temporary tablespaces and undo tablespaces. Apologies, I can't find the document IDs at the moment.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mir M. Mirhashimali Sent: Friday, March 07, 2008 8:53 AM
To: Thomas.Mercadante_at_labor.state.ny.us
Cc: genegurevich_at_discover.com; oracle-l_at_freelists.org Subject: Re: Is is safe to drop old temp space?

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_at_freelists.org

> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of

> genegurevich_at_discover.com

> Sent: Friday, March 07, 2008 11:28 AM

> To: oracle-l_at_freelists.org

> Subject: Is is safe to drop old temp space?

>

> 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

>

>

>

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>

> !DSPAM:59,47d17243156591348146124!

>

>

>   

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l