Is is safe to drop old temp space?

  • From: genegurevich@xxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 7 Mar 2008 10:27:32 -0600

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


Other related posts: