RE: ORA-1555 error with AUM already enabled
From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Wed, 26 May 2010 07:36:58 -0600
Message-ID: <86DB933313FD7B4B9713942084783C8D083EE653_at_COENGEXCMB01.cable.comcast.com>
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.
Date: Wed, 26 May 2010 07:36:58 -0600
Message-ID: <86DB933313FD7B4B9713942084783C8D083EE653_at_COENGEXCMB01.cable.comcast.com>
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.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Madhu Sreeram
Sent: Tuesday, May 25, 2010 8:44 PM
To: janine_at_furfly.net
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 26 2010 - 08:36:58 CDT