18-12. How to avoid generating REDO entries

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:
  

  UNRECOVERABLE
  LOAD DATA
  INFILE 'sample.dat'
  INTO TABLE emp
  (ename VARCHAR2(10), empno NUMBER(4));