Alter table in archive log mode database

[slimdave]

Create a new table with the nologging attribute, that includes all the current columns plus the new column.

Then you can either replace the old table with the new one, or ...

truncate the old one, add a new column to it, set it to nologging, disable the indexes, and "insert /*+ append */ " the rows from the "new_table"