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