Re: Oracle ORA-1555 Snapshot Too Old error

E. Fong wrote:
>
> Anyone,
>
> I having a problems getting an ORA-1555 Snapshot too old error while trying
> to load a large set of data into a table. The batch job is run a not
> concurrently with other nightly batch jobs and generally runs an hour long.
> It seems that the rollback segments have been aged out by the end of the
> run. I have tried using a larger rollback segment but hasn't helped.
>
> Does anyone have any insight to a solution for this problem?
>
> Wondering,
>
> E. Fong

Rollback segment used by transaction is too small. Try to create much larger rollback segment ( in sense of size per extent and number of extents ) and assign it to your transaction. Halina Monka
job ( set transaction use Received on Thu Oct 24 1996 - 00:00:00 CEST