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
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
![]() |
![]() |