title: Load data via SQL * Loader in IDENTITY column in Oracle 12c
body: <p>I need to load data using SQL* Loader into Oracle table with GENERATE ALWAYS AS IDENTITY</p>
  
  <pre><code>CREATE TABLE tbl_identity
  (
    col1 NUMBER(10,0) GENERATED ALWAYS AS IDENTITY(START WITH 7 INCREMENT BY 1)    NOT NULL,
    col2 VARCHAR2(20)
  );
  </code></pre>
  
  <p>But when I try to load data in this table, I get an error </p>
  
  <pre><code>ORA-32795: cannot insert into a generated always identity column
  </code></pre>
  
  <p>Maybe there are any option in SQLLDR which skip IDENTITY for a while?</p>
  
  <p>Or maybe there are any ideas how I can load data into GENERATED ALWAYS IDENTITY column using SQLLDR?</p>
  
  <p>SQLLDR command</p>
  
  <pre><code>sqlldr userid=user/passw@TNS control=tbl_identity.ctl log=tbl_identity.log rows=1000 readsize=65535 bindsize=65535
  </code></pre>
  
  <p>CTL-file</p>
  
  <pre><code>OPTIONS(direct=false)
  LOAD DATA
  INFILE 'tbl_identity.txt'
  INTO TABLE tbl_identity
  INSERT
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
  (col1,
   col2)
  </code></pre>