Need help performing large updates...

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';

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?

Thanks in advance,

Eric Ladner          | UNIX/Oracle/Passport Sys-Administration, General
clad_at_chevron.com     | Applications Development, etc., etc. 


========================================================================