RE:SNAPSHOT TOO OLD (1555) - SOLUTION ?

The first thing might be to increase the size of your rollback segments. Failing that
declare a rowid type array (depends on the size of the order table) and go through your order records first collecting the rowids for your order table in to the array, close the cursor and then find a record from the order table using the rowid and perform any processing..
Unfortunately I am not a PRO*C programmer... Hope this helps..

> -----Original Message-----
> From: djose_at_att.com [SMTP:djose_at_att.com]
> Posted At: 26 February 1998 14:04
> Posted To: server
> Conversation: SNAPSHOT TOO OLD (1555) - SOLUTION ?
> Subject: SNAPSHOT TOO OLD (1555) - SOLUTION ?
>
> Hello everyone,
>
> I have a Pro*C program which churns through 4 tables and
> creates a flat
> file. The program encounters oracle error code ORA-1555
> (SNAPSHOT TOO
> OLD ) causing it to exit.( I have an exit routine for non-zero
> return codes )
>
> The tables are as follows
>
> order
> order_details
> name
> address
> * The program basically creates a cursor on order table which pulls
> out all
> rows in that table.
> * For each order it pulls out data from the other 3
> tables.
> * I use a host array for the FETCHES with a batch size of 2000.
> * I
> also use the PARALLEL QUERY OPTION.
> * The program currently takes about 4-5
> hours to run.
> * The volumes in these tables are very high and transactions
> are continously
> updating the above tables.
>
>
> My Question :
> Is there any
> way I can work around the snapshot too old error ?
> Any help with respect to
> handling this error would
> be very much appreciated.
>
>
> Thanks for your time,
> Jude
>
> ( djose_at_att.com )
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/ Now offering spam-free web-based
> newsreading
Received on Fri Feb 27 1998 - 00:00:00 CST