Re: Is is safe to drop old temp space?
- From: "Mir M. Mirhashimali" <mhyder@xxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
- Date: Fri, 07 Mar 2008 10:52:56 -0600
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
!DSPAM:59,47d17243156591348146124!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
