ERROR: snapshot too old

From: Lasse Berntzen <lbe_at_odont.uio.no>
Date: Wed, 13 May 1998 23:38:27 +0200
Message-ID: <6jd3rg$ec6$1@ratatosk.uio.no>

I have written a conversion program in PL/SQL. Since last time I performed the conversion, the original table has grown, and I now get the following error
message:

ORA-015555: snapshot too old: rollback segment number 6 with name "RB5" too small

I am running Oracle 7.3 on Windows-NT 4.0.

Every insertion into a table is followed by a commit. I thought a commit released the
entries in the rollback segment. I checked the rollback segment, and it has a lot of
free space. Is someone able to explain what is happening here? And what is the solution?

(It seems that the PL/SQL program blocks other processes from executing..?)

Thank you in advance

Lasse Berntzen
lbe_at_odont.uio.no Received on Wed May 13 1998 - 16:38:27 CDT