RE: Is is safe to drop old temp space?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 7 Mar 2008 12:22:18 -0500
Message-ID: <024001c88077$ccb11500$1100a8c0@rsiz.com>

It if is truly a temporary tablespace you should be all set. If it is an old style permanent tablespace that is assigned as temporary it is possible that someone with the right credentials could have stored a permanent table or index there. However, in that case, unless you use the "including contents" keywords on the drop tablespace command Oracle should refuse the drop.

Hmm. I guess it would have been shorter to say that if drop tablespace temp works without any keywords then you should be just fine.

mwf

-----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 Received on Fri Mar 07 2008 - 11:22:18 CST

This message: [ Message body ]
Next message: Stephens, Chris: "RE: strategies for optimizing 'like' operations"
Previous message: Harvinder Singh: "How to allocate keep cache on 32 bit linux using VLM"
In reply to: genegurevich_at_discover.com: "Is is safe to drop old temp space?"
Next in thread: genegurevich_at_discover.com: "Is is safe to drop an empty tablespace?"
Reply: genegurevich_at_discover.com: "Is is safe to drop an empty tablespace?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message