Updating table containing millions of records

[jhmartin]

If this is a one-time update you could do a create table as select nologging with the new format then swap the tables at the end.