Re: intermittent commits

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 20 May 1999 11:12:32 -0400
Message-ID: <7i18j3$t35$1@autumn.news.rcn.net>

Hi Doug,

Have you considered using PL/SQL with outer and inner loops? Outer loop will handle the entire table by repeatedly calling the inner loop (which can to the updates) and a commit every time the inner loop is completed.

I think this is a cleaner solution that is simpler to implement and maintain.

regards

Jerry Gitomer

Doug Cowles wrote in message <37441EAC.7291CCAF_at_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?
>
>- Dc.
>
Received on Thu May 20 1999 - 10:12:32 CDT