title: external table in oracle?
body: <p>hi friends i have tried to load data from flat file to external file using oralce_loader access driver my code is </p>
  
  <pre><code>create  table test_ext (
      id_1 varchar(35),
      emp_name varchar(25),
      e_mail varchar(25)) 
  organization external (
      type oracle_loader default directory new_dir access parameters
          ( records delimited by newline fields(
               id_1 char(30),
               e_name char(25),
               mail char(25)))
      location('test.csv')) reject limit unlimited;
  </code></pre>
  
  <p>and my data file:</p>
  
  <pre><code>"E.FIRST_NAME||','||E.EMAIL||','||MANAGER_ID"
  -----------------------------------------------
  "Jennifer,JWHALEN,101"
  "Michael,MHARTSTE,100"
  "Susan,SMAVRIS,101"
  "Hermann,HBAER,101"
  "Shelley,SHIGGINS,101"
  "William,WGIETZ,205"
  "Steven,SKING,"
  "Neena,NKOCHHAR,100"
  "Lex,LDEHAAN,100"
  "Alexander,AHUNOLD,102"
  "Bruce,BERNST,103"
  "David,DAUSTIN,103"
  "Valli,VPATABAL,103"
  "Diana,DLORENTZ,103"
  "Nancy,NGREENBE,101"
  "Daniel,DFAVIET,108"
  "John,JCHEN,108"
  </code></pre>
  
  <p>while run that above query i got </p>
  
  <pre><code>**ORA-29913: error in executing ODCIEXTTABLEOPEN callout
  ORA-29400: data cartridge error
  KUP-04043: table column not found in external source: EMP_NAME
  29913. 00000 -  "error in executing %s callout"
  *Cause:    The execution of the specified callout caused an error.
  *Action:   Examine the error messages take appropriate action.**
  </code></pre>
  
  <p>I tried so many things but I can't.</p>