Precisely herodt, the NOLOGGING in the SELECT as you proved is basically an alias. The table you are inserting into needs to be defined as NOLOGGING when in ARCHIVELOG mode in order to reap the benefits of reduced logging.