Re: Undo Management

shirleyr_at_mailings.com wrote:
> Hi,
>
> I did most of my work on Oracle 8i using rollback segments. I just
> took a new job where they didn't have a DBA before and are using Oracle
> 9i and 10g. They have Undo tablespaces instead of rollback segments.
> Does undo tablespaces work like rollback segements? Can someone point
> me to some reading to explain how they should be set up and how they
> work. We have a long transaction that has been running at night and it
> gets 'snapback too old' error message. But I don;t know how the undo
> is working. Should I remove all the undofile to have just one undofile
> to use all the space for this transaction?

What possessed you to ask these questions here rather than read the docs on UNDO at tahiti.oracle.com? That should have been the first place to turn.

But to answer your question: basically ... both yes and no.

Now go read the docs. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)