title: external table file to load omitting columns
body: <p>I need to upload data from file to external table in oracle, but do not need all the columns defined in the file,
  So far i've tried this</p>
  
  <pre><code>CREATE TABLE test_tbl(
     col1 number,
     col2 varchar2(10),
     col3 varchar2(10),
     col4 varchar2(10),
     col5 varchar2(10)
  )
   ORGANIZATION EXTERNAL(
      TYPE ORACLE_LOADER
       DEFAULT DIRECTORY MY_DIR
       ACCESS PARAMETERS(
         RECORDS DELIMITED BY NEWLINE
          FIELDS TERMINATED BY ','
          (
             col1 ,
             filler ,
             col3 ,
             col4 ,
             filler
           )
      )
   LOCATION(
       'myfile.txt'
         )
  )
  </code></pre>
  
  <p>by consulting the table generates this error</p>
  
  <blockquote>
    <p>ORA-29913: error al ejecutar la llamada de ODCIEXTTABLEOPEN <br>ORA-29400:
    error de cartucho de datos <br>KUP-04043: table column not found in
    external source: col2</p>
  </blockquote>
  
  <p>file structure: 0111,column,testing,name,address</p>