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