RE: ORA-1555 error with AUM already enabled

From: Walker, Jed S <>
Date: Wed, 26 May 2010 07:36:58 -0600
Message-ID: <>

I agree with Madhu, retention is not a guarantee only a suggestion to oracle on how much to keep around. Use the undo retention guarantee temporarily to get your work done.  

[] On Behalf Of Madhu Sreeram Sent: Tuesday, May 25, 2010 8:44 PM
Cc: oracle-l L
Subject: Re: ORA-1555 error with AUM already enabled  

Try again with a guaranteed retention (alter tablespace <undo> retention guarantee). This can cause some side effects, so you should probably revert the changes after you are done. If you want to make this a permanent setting you should size the tablespace big enough , or you may run into "unable to extend segment" errors in the Undo tablespace.

-Madhu Sreeram

Received on Wed May 26 2010 - 08:36:58 CDT

Original text of this message