Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> intermittent commits
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?
![]() |
![]() |