Tom Kyte On Large Scale Updating Without Rollback Issues

Tom Kyte on updating a multi-million row table without encountering rollback issues:

"If I had to update millions of records I would probably opt to NOT update. 
I would more likely do: 

CREATE TABLE new_table as 
	select <do the update "here"> from old_table; 

index new_table 
grant on new table 
add constraints on new_table 
etc on new_table 

drop table old_table 
rename new_table to old_table; 

you can do that using parallel query, with nologging on most operations 
generating very little redo and no undo at all -- in a fraction of the time 
it would take to update the data."

Nice one Tom. That's an approach I wouldn't have thought of, but i'll definately use next time.