This discussion is archived
2 Replies Latest reply: Sep 2, 2013 10:07 PM by Ankur ... RSS

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Ankur ... Explorer
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points