Re: ORA-01555 error

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Mon, 05 Dec 2005 01:55:23 GMT
Message-ID: <Xns9722B65A9AC5DSunnySD@70.168.83.30>

"kwr2k" <Kanwar.Plaha_at_gmail.com> wrote in news:1133742197.959227.119420_at_z14g2000cwz.googlegroups.com:

> Okay, thanks for all the replies. I have googled for this issue (ad
> nauseam, actually). However, there haven't yet seen a satifactory
> explanation hence I decided to raise it at this forum to get specific
> answers.
>
> Anyway, two things stand out clearly from all your suggestions:
>
> 1. Increase rollback segment size -- Yes, I am going to try this next
> as soon as the application team is ready
> 2. Get a new vendor -- Yes, I would love to do this but is an
> impossibility given the size and stage of the project we are in ;)
>

One common cause of ORA-01555 is when a COMMIT exists within a long running cursor that is changing (INSERT/UPDATE/DELETE) data. Received on Sun Dec 04 2005 - 19:55:23 CST