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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Dean Paul
> Sent: Wednesday, November 29, 2006 6:37 PM
> To: oracle-l_at_freelists.org
> 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