RE: ORA-1555 error with AUM already enabled
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: <madhusreeram@xxxxxxxxx>, <janine@xxxxxxxxxx>
- Date: Wed, 26 May 2010 07:36:58 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Madhu Sreeram
Sent: Tuesday, May 25, 2010 8:44 PM
To: janine@xxxxxxxxxx
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
Other related posts: