Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> intermittent commits

intermittent commits

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Thu, 20 May 1999 10:39:40 -0400
Message-ID: <37441EAC.7291CCAF@bigfoot.com>


How do you update a 700,000 row table with intermittent commits? There is a script on www.orafaq.org that is in blatent violation of the fetch out of sequence problem. It selects for update and then commits in between,
which doesn't work. I was thinking of selecting min and max rowid's and breaking
them into batches. Any ideas?

Received on Thu May 20 1999 - 09:39:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US