Re: snapshot too old problem

Iancrozier wrote:
>
> When running a program to change certain values in an Oracle table, I get the
> following message after about 3000 rows have been updated:-
> 0RA-01555; snapshot too old: rollback segment number 1 with name "R05"
>
> We have tried increasing the size of our rollback files, but we still get this
> problem.
> Anyone have any suggestions? TIA

Your rollback segments appear too small for the updates you are attempting.

Try creating a spacially large rollback segment for this transaction, you can change to this rollback segment by issuing

SET TRANSACTION USE ROLLBACK SEGMENT xxxx

Also, check for other concurrent processes trying to access the same data as your update. You could also try and commit in blocks, say every 100 records, or parallellise the updates by grouping in ranges.

Hope this helps,

Andy Received on Tue Jun 02 1998 - 11:26:45 CDT