Re: ERROR: snapshot too old

From: Simon Clifford <sclifford.nospam_at_cyberus.ca>
Date: Thu, 21 May 1998 09:37:20 -0400
Message-ID: <35642E10.71A2@cyberus.ca>

Lasse Berntzen wrote:
>
> 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.
>
> Lasse Berntzen
> lbe_at_odont.uio.no

There is a very good discussion of this type of problem, in Canadian BBS #2974 and #1565. I'd suggest looking them up, and it might help.

Regards,
Simon

--

---

to reply, remove the ".nospam" from the address Received on Thu May 21 1998 - 08:37:20 CDT