Oracle ORA-1555 Snapshot Too Old error
From: E. Fong <efong_at_val.net>
Date: 1996/10/24
Message-ID: <01bbc17a$113be750$287d93c6_at_efong>#1/1
Date: 1996/10/24
Message-ID: <01bbc17a$113be750$287d93c6_at_efong>#1/1
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 Thu Oct 24 1996 - 00:00:00 CEST