Re: ORA-01555

The easiest way to get around this error is to increase the size of your rollback segment's next extent. Try:
alter rollback segment rbs01 storage (next 10m); Or you could rebuild the RB segments with a higher initial,next parameter. Finally, you could create a large RBS just to handle data intensive applications. The application developer will then be able to assign these long running transations explicitly to it (the large RBS).

M.Landa

%username% 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
Received on Sun Feb 08 1998 - 00:00:00 CST