12 Replies Latest reply: Sep 18, 2010 6:43 AM by user8731258 RSS

    ORA-29913: error in executing ODCIEXTTABLEOPEN callout

    user8731258
      create table external
      (empno number(4),
      ename varchar2(10),
      job varchar2(9),
      mgr number(4),
      hiredate date,
      sal number,
      comm number,
      deptno number(2)
      )
      organization external
      (type oracle_loader
      default directory data_dir
      access parameters
      (fields terminated by ',')
      location('emp.dat')
      )
      /
      table created
      But when i run the statement
      sql>select count(*) from external;
      i get an error

      {error}
      ERROR at line 1:
      ORA-29913: error in executing ODCIEXTTABLEOPEN callout
      ORA-29400: data cartridge error
      KUP-04063: unable to open log file EXTERNAL_4295.log
      OS error No such file or directory
      ORA-06512: at "SYS.ORACLE_LOADER", line 19
      {error}