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 - 11.2.0.1

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

01,Accounting

02,IT

03,Admin

04,Marketing

 

 

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

Legend

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