Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to handle updates to millions of rows
Peter Mueller wrote:
> Thanks for the hint and sorry for not mentioning all the
> details. Next time I will post them.
>
> PS: For those that are still interested: DB = Oracle 9i
>
> Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:
>
>>First of all, as already mentioned, get rid of the >>commit inside the loop - it *causes* the 1555! >>Secondly, always mention basics, as platform and versions; >>who knows, you could have been using the merge command...
In that case: lookup the merge command - it's far more
efficient than any PL/SQL!
See:
http://asktom.oracle.com/pls/ask/f?p=4950:8:2999541794298325973::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6618304976523,
-- Regards, Frank van BortelReceived on Thu Aug 26 2004 - 04:54:15 CDT