External table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout
<p>I am trying to use oracle external table feature to load flat file into database but encounter a error while execute SELECT statement on external table which i have created.
Below are the exact steps that  i am following --</p>

<pre><code>/user2/cbusdev01/smp43/domains/columbus/tools&gt;mkdir data_1
/user2/cbusdev01/smp43/domains/columbus/tools&gt;chmod 777 data_1
</code></pre>

<p>create a file inside the data_1 folder add_len.csv
    Barbados_1000230,2461000230,2461000230,SSLN 00 0 00 138
    Barbados_1000229,2461000229,2461000229,SSLN 00 0 00 139
    Barbados_1000228,2461000228,2461000228,SSLN 00 0 03 14</p>

<p>login to sysdba --
    grant create any directory to cbusdev01cm;
    grant read, write on DIRECTORY data_1 to cbusdev01cm;</p>

<p>Now create a external table --</p>

<pre><code>CREATE TABLE add_len_ext (
  country_code      VARCHAR2(20),
  sip               NUMBER,
  tn                NUMBER,
  len               VARCHAR2(30) 
)
ORGANIZATION EXTERNAL (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY data_1
  ACCESS PARAMETERS (
    RECORDS DELIMITED BY NEWLINE
    BADFILE data_1:'bad.bad'
     LOGFILE data_1:'log.log'
    FIELDS TERMINATED BY ','
    MISSING FIELD VALUES ARE NULL
    (
      country_code      CHAR(50),
      sip               CHAR(50),
      tn                CHAR(50),
      len               CHAR(50)
    )
  )
  LOCATION (data_1:'add_len.csv')
)
PARALLEL 5
REJECT LIMIT UNLIMITED;

Table ADD_LEN_EXT created.
</code></pre>

<p>Then i fire the SELECT statement </p>

<pre><code>select * from ADD_LEN_EXT;
</code></pre>

<p>And it gives me --</p>

<pre><code>ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /user2/cbusdev01/smp43/domains/columbus/tools/log.log
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 am not getting this error !!
I have granted all the permission to concerns but still the error is coming.</p>

<p>I am using --</p>

<pre><code>Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
</code></pre>