Option 1:
Insert statement with:
table mode: NOLOGGING
insert mode: APPEND
archivelog mode: noarchive log mode
Option 2:
CTAS with NOLOGGING mode
Both options above would generate no redo log. Which one is better for performance? I'm loading large volume or rows (a few million) on a daily basis and this is a staging table so there is no problem to reprocess in case of failure.