title: does not load data through sqlloader
body: <p>I have a table in the oracle database: TABLESPACES and, columns DATA_TIME is  type: date. 
  And a data file that wants to patch like this:</p>
  
  <pre><code>    ALTAIR          ;08-01-2019 10:33:28       ;SUB_DATA
      ALTAIR          ;08-01-2019 10:33:28       ;SUB_IDX
      ALTAIR          ;08-01-2019 10:33:28       ;SYSAUX
  </code></pre>
  
  <p>my control file looks like:</p>
  
  <pre><code>    load data
      infile '/home/oracle/space_monitor/logs/space_monitor.log'
      INTO TABLE TABLESPACES
      APPEND
      Fields terminated by ";"
      (
      DB "TRIM(:DB)",
      DATA_TIME "TRIM(:DATA_TIME)",
      NAME "TRIM(:NAME)"
      )
  </code></pre>
  
  <p>when trying to load data i have error:</p>
  
  <pre><code>    Record 1: Rejected - Error on table TABLESPACES, column DATA_TIME.
      ORA-01843: not a valid month
  </code></pre>
  
  <p>when I make changes to the control with TIMESTAMP file like this:</p>
  
  <pre><code>    load data
      infile '/home/oracle/space_monitor/logs/space_monitor.log'
      INTO TABLE TABLESPACES
      APPEND
      Fields terminated by ";"
      (
      DB "TRIM(:DB)",
      DATA_TIME "to_date(:TIMESTAMP, 'DD-MM-YYYY HH24:MI:SS')",
      NAME "TRIM(:NAME)"
      )
  </code></pre>
  
  <p>i have error:</p>
  
  <pre><code>    SQL*Loader-291: Invalid bind variable :TIMESTAMP in SQL string for column DATA_TIME.
  </code></pre>
  
  <p>In my database oracle parameters:</p>
  
  <pre><code>    NLS_DATE_FORMAT like RR/MM/DD
      NLS_TIMESTAMP_FORMAT like RR/MM/DD HH24:MI:SSXFF
  </code></pre>
  
  <p>Please help me.</p>