Re: Oracle ORA-1555 Snapshot Too Old error

Two things you can try:

(1) Create a BIG rollback segment (try 500MB or larger); (2) Commit more often.

Be aware that you have to set the transaction using the BIG rollback segment whenever a new transaction starts.

Xiaoying Yu (xyu_at_osf1.gmu.edu or xiaoying.yu_at_cwi.cablew.com)

On 24 Oct 1996, E. Fong wrote:

> Date: 24 OCT 1996 07:35:01 GMT
> From: E. Fong <efong_at_val.net>
> Newgroups: comp.databases.oracle
> Subject: Oracle ORA-1555 Snapshot Too Old error
>
> 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
>
>
  Received on Wed Oct 30 1996 - 00:00:00 CET