Even though a database is in archive log mode, it’s possible to individually disable logging for a particular table. To do so:

• Set the NOLOGGING attribute for the table or

• Specifying the UNRECOVERABLE Clause in the Control File. Example:

  UNRECOVERABLELOAD DATAINFILE 'sample.dat'INTO TABLE emp(ename VARCHAR2(10), empno NUMBER(4));