There is always tradeoff.
Convert from archivelog-noarchivelog-archivelog requires two time database restart and invalided all backup of that database.
Recreate that table via nologging etc need double space, and you need recreate all the index, constraints etc, this also takes a lot of time.
..




Reply With Quote