Re: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small

> Well, if this script receives ORA-1555 on regular basis, then you
> should increase undo_retention to cover the longest run time period of
> this query so that Oracle retains undo needed by it for the whole
> duration of the process (say, undo_retention=22000.) Or better try to
> optimize that script so that it takes less time to complete, ideally
> less than 3 hours.

Additionally, make sure that your UNDO tablespace is sufficiently large to hold all of this undo.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown