Re: Is is safe to drop old temp space?
From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Fri, 07 Mar 2008 10:52:56 -0600
Message-ID: <47D172E8.30402@rice.edu>
Date: Fri, 07 Mar 2008 10:52:56 -0600
Message-ID: <47D172E8.30402@rice.edu>
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:Received on Fri Mar 07 2008 - 10:52:56 CST
> 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