Re: Oracle error 1555 snapshot too old

Try increasing your rollback's segment size....

Let me know if this helps
Philippe Backouche
philippe_at_arpege.imaginet.fr

Dave Wotton a écrit :

> Eric DUCHET wrote in message ...
> >I 've got the Oracle message Snaptshot too old......
> >
> >Does anybody explain me why this message appears ?
> >I commit my transaction every 1000 rows.
> >I don't understand what's happening.
>
> See my web-page:
>
> http://home.clara.net/dwotton/dba/snapshot.htm
>
> You should find it explains everything :-)
>
> Dave.
> --
> There's no need to reply to this posting by email, but if you do,
> remove the "nospam" from my email address first.
Received on Mon Dec 06 1999 - 16:02:13 CST