most expeditious way to update a large number of rows

Hello. I need to update a single column in every row of a large table (671 000 rows.)

In order to prevent the redo logs from filling faster than Oracle can archive them, I set up a loop to update 5000 rows at a time, commit, and then sleep for two seconds.

The log archiver was able to keep up, but I estimate that it'll take about 74 hours for every row to be updated. I cannot use "nolog" as I have a physical standby database that depends on the archived redo logs.

Thanks in advance for any hints!
Myles Received on Mon Oct 16 2006 - 10:11:43 CDT