Re: ORA-01555

In article <34DB3A12.4321_at_ic.gc.ca>, %username% <duong.liem_at_ic.gc.ca> wrote:
>Hope someone can help us on this.
>
>We are running a SQR program on the UNIX server that updates the value
>of Emplid's on the TEST database.
>
>For each emplid on the database, the program will perform over 300
>SELECT statements to verify if there is any data for the old emplid. If
>so, it will build an UPDATE SQL statement to change the value to the new
>emplid. In average, the program will update about 13 tables.
>
>Once all the updates done for that employee, the program issues a COMMIT
>STATEMENT. Then it does the above process for the next employee.
>
>The program stops with the error message ORA-01555: snapshot too old
>(rollback segment too small).
>
>Any help is apreciated.
>
>Liem Duong
>PeopleSoft Project
>Industry Canada
>duong.liem_at_ic.gc.ca

Make bigger rollback segments! There is also a whitepaper on 1555, but you should try fixing the error first. See ALTER DATABASE in your sql manual if you need to resize your rollback tablespace, look into SET TRANSACTION USE ROLLBACK SEGMENT for explicitly using a particular large rollback segment for the problem program, see your administrators guide on sizing the rollbacks, and see your Concepts Manual to explain what is going on.

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!