Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ERROR: snapshot too old

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US