6 Replies Latest reply: Sep 3, 2013 4:18 AM by Ankur ... RSS

    ORA-29913: error in executing ODCIEXTTABLEOPEN callout

    Ankur ...

      Hi Experts,

      Please help to fix the above error, I have mentioned all the steps I have performed.


      DB Version -

      OS Version - OEL6(64 bit)


      SQL> show parameter utl_file


      NAME                     TYPE     VALUE

      ------------------------------------ ----------- ------------------------------

      utl_file_dir                 string

      SQL> alter system set utl_file_dir='/u01/feeder' scope=spfile;


      System altered.


      SQL> startup force;

      ORACLE instance started.


      Total System Global Area  634679296 bytes

      Fixed Size            2216024 bytes

      Variable Size          507514792 bytes

      Database Buffers      121634816 bytes

      Redo Buffers            3313664 bytes

      Database mounted.

      Database opened.

      SQL> exit


      SQL> create directory feeder as '/u01/feeder';


      Directory created.


      SQL> !cat depts.txt







      SQL> create table depts (deptno number (2), deptname varchar2(16))

      organization external (

      type oracle_loader

      default directory feeder

      access parameters

      (records delimited by newline

      badfile 'depts.bad'

      discardfile 'depts.dsc'

      logfile 'depts.log'

      fields termintated by ':'

      missing field values are null)

      location ('depts.txt'));


      Table created


      SQL> select * from depts;

      select * from depts


      ERROR at line 1:

      ORA-29913: error in executing ODCIEXTTABLEOPEN callout

      ORA-29400: data cartridge error

      KUP-00554: error encountered while parsing access parameters

      KUP-01005: syntax error: found "identifier": expecting one of: "column,

      enclosed, ignore_chars_after_eor, (, ltrim, lrtrim, ldrtrim, missing, notrim,

      optionally, rtrim, reject, terminated"

      KUP-01008: the bad identifier was: termintated

      KUP-01007: at line 5 column 8