HELP ORA-01555 - snapshot too old.....

Hello !
in a PL/SQL procedure, i've got a problem........... withe this ORA-01555

in my procedure i've got :

an update in a loop, this loop is conditionned by a cursor. the commit is, of course, before the end of the loop...

a max of 80 Mb is commited in a loop.

my rollback segment : 3 Gb.......... with an initial of 195

Mb...................

and I wonder why the ORA-01555 occurs..................................

Thanks a lot for your help !!!!!!!!!!!

;oD Received on Wed Jun 26 2002 - 10:02:15 CDT