Re: Snapshot too old

From: K POON <kspoon_at_netvigator.com>
Date: Wed, 26 Aug 1998 21:42:37 +0800
Message-ID: <35E410CD.AC05A1D5@netvigator.com>

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 - 08:42:37 CDT