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@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mir M. Mirhashimali
Sent: Friday, March 07, 2008 8:53 AM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Cc: genegurevich@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@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 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


Other related posts: