create table t as select * from all_objects where 0=1;
set autotrace on stat
insert /*+ append */ into t select * from all_objects

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> create table test as select * from all_objects where 1=0;

Table created.

SQL> insert /*+ append */ into test select * from all_objects;

49225 rows created.


Statistics
----------------------------------------------------------
       6357  recursive calls
        962  db block gets
      79608  consistent gets
          1  physical reads
    5604512  redo size
        657  bytes sent via SQL*Net to client
        587  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
      49225  rows processed

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL> create table test as select * from all_objects where 1=0;

Table created.

SQL> insert /*+ append */ into test select * from all_objects;

49227 rows created.


Statistics
----------------------------------------------------------
       6210  recursive calls
        964  db block gets
      79561  consistent gets
          1  physical reads
      43512  redo size
        655  bytes sent via SQL*Net to client
        587  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
      49227  rows processed