Re: UNDO TABLESPACE

Why would you want to change to manual which requires an instance shutdown/restart? Then another shutdown/restart when you want to change back to auto? 

You can create a new undo tablespace while the instance is running.
1) Create a new undo tablespace with a new name.
2) alter system set undo_tablespace = new_name scope = both
3) drop old undo tablespace (when all current transactions are done with it)
Of course, as Sam points out, the real question is "Why?" Is it to 'fix' a problem that will happen again? Or is it because of a one time problem? 

Regards,
Daniel Fink

Sam Chakkanat wrote:

Seems like you are using automatic UNDO?  Logically, you could do this by
changing the UNDO
to manual first, by creating other rollback segments on another tablespace.
Once you transfer
all the transactions to use the new rollbacks you could take the UNDO
tablespace down and recreate.

But just a thought - Why do you need to re-create the UNDO?

Any comments geeks?

Sam.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dean Paul
Sent: Wednesday, November 29, 2006 6:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: UNDO TABLESPACE 
Hi,

I want to drop undo tablespace.
and recreate it.What would be best way?
Thanks

_________________________________________________________________
Fixing up the home? Live Search can help
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=e
n-US&source=hmemailtaglinenov06&FORM=WLMTAG

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: