Re: Snapshot too old
From: K POON <kspoon_at_netvigator.com>
Date: 1998/08/26
Message-ID: <35E410CD.AC05A1D5_at_netvigator.com>#1/1
Date: 1998/08/26
Message-ID: <35E410CD.AC05A1D5_at_netvigator.com>#1/1
Try to make more RBS and make the RBS large enough to hold more changes. Also try to schedule the data loading at a less busy time.
Danny Poon
David Ng wrote:
> Hi,
>
> I got a problem with a data loading program. The program always terminated
> with Oracle error
> of "Snapshot too old" even the program commit evey 50 record. In other
> word, each commited transaction should be small enough for the database
> rollback segment.
>
> Any idea ? Thank in advance to whoever comment. .
>
> David
>
Received on Wed Aug 26 1998 - 00:00:00 CEST