Re: Need help performing large updates...

C. Eric Ladner 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:
>
> update foo set bar = 'NEW' where bar = 'OLD';
>

What you need is a VERY LARGE rollback segment that you can temporarily put online during these updates. Set the initial/next extent size to 1/100 of the size and the pctincrease to 0%. There have been times where I needed a 2GB rollback.

-- 
Ronald Leedy                                     SSSS  V     V   CCCCC
Silicon Video Corp                              S      V     V  C
mailto:rleedy_at_svc.com                            SSS    V   V   C
1-408-229-6150 voice                                S    V V    C
1-408-229-0850 fax                              SSSS      V      CCCCC