Re: Rollback/Undo in 9i

From: Dave <x_at_x.com>
Date: Tue, 05 Apr 2005 22:50:32 GMT
Message-ID: <YCE4e.4759$G8.363@text.news.blueyonder.co.uk>

"DW" <dwhittier_at_shaw.ca> wrote in message news:1112741138.994413.28340_at_g14g2000cwa.googlegroups.com...
> Greetings...
>
> I have a number of instances running under 9i (9.2.0.4, about to patch
> to 9.2.0.6).
>
> My organization wants to investigate using undo instead of the rollback
> segments that we currently use.
>
> I'm looking for a discussion about 'migrating' to undo versus rollback:
> recommended process, gotchas, and backing out afterwards.
>
> Are there any articles anyone can think of which discuss this?
>
> Thanks!
>
> DW
>

create an undo tablespace same size as your rollback tablespace - turn undo on and voila - never look back. It works and works well, no gotchas (i hate that word) and no need to back out Received on Tue Apr 05 2005 - 17:50:32 CDT