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 -> Re: how to handle updates to millions of rows

Re: how to handle updates to millions of rows

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 26 Aug 2004 11:54:15 +0200
Message-ID: <cgkbjn$lud$1@news2.tilbu1.nb.home.nl>


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 Bortel
Received on Thu Aug 26 2004 - 04:54:15 CDT

Original text of this message

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