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: Peter Mueller <lord.of.board_at_gmx.de>
Date: 26 Aug 2004 00:49:08 -0700
Message-ID: <e3b18ff5.0408252349.1c1d1fad@posting.google.com>


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...
Received on Thu Aug 26 2004 - 02:49:08 CDT

Original text of this message

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