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: Most efficient large update?

Re: Most efficient large update?

From: broom <broom_at_voicenet.com>
Date: 27 May 2001 07:42:54 -0700
Message-ID: <c948eb61.0105270642.310ed246@posting.google.com>

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:<3B106A54.64822210_at_exesolutions.com>...
> You try to update 100,000 records in one shot and you will likely not
> succeed due to rollback segment space.

Actually, no. I can throw 50GB at single use RBS if I need it. I'm aware of the issues concerning rbs activity. The key issue is the amount of time related the updates. Any hints in that direction? Received on Sun May 27 2001 - 09:42:54 CDT

Original text of this message

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