ORA-01555

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 Received on Fri Feb 06 1998 - 00:00:00 CST