Re: Need help performing large updates...

In article <316971E7.2781_at_chevron.com>, C. Eric Ladner <clad_at_chevron.com> wrote:
>I have a couple of huge tables (>500,000 rows) that need to be updated.
>The nature of the update causes every row to be changed. The problem
>I'm running into is that I keep running out of extents in the rollback
>segments. This is using just a regular SQL statement like:

have you tried to increase the size of your RBS by adding another datafile and increasing the size of the extents?

some time ago we did an update to a table with over 20,000,000 rows and we created one large Rollback-segment with 1.5 Gigabytes and an extent-size of 500 Megabytes. At the beginning of the update as the first statement we used 'set transaction use rollback segment RBS_BIG' to select this big segment and it worked fine.

>
> update foo set bar = 'NEW' where bar = 'OLD';
>
>
>The only way I can seem to get it done is to break it up into a bunch of
>sub-updates that get about 20 percent of the table.
>
>Is PL/SQL an option? Would it allow me to get around the space
>limitation I'm having with the RBSegs?

I don't know, because we did not need something like this.

>
>Thanks in advance,

Hope, it helps

Greetings from

Harry

-- 
----------------------------------------------------------------------
  Harald (Harry) Becker                 harry_at_merlin.unterland.de   
      75223 Niefern                     for PGP-Key send mail to:
                                        harry_key_at_merlin.unterland.de