Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout (Oracle 9i)
Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout [message #519428] Fri, 12 August 2011 02:04 Go to next message
gilbert_makinana
Messages: 5
Registered: August 2011
Location: CAPE TOWN
Junior Member

Hi there masters

I have a problem here I am using this script to create an external table

CREATE TABLE SUPP_GIM.T_CSV_DATA
(
UPC VARCHAR2(30),
AGEIND VARCHAR2(30),
DEPT VARCHAR2(30),
CREG VARCHAR2(30),
SUPP VARCHAR2(30),
PRICE VARCHAR2(30),
TYPE VARCHAR2(30)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY DUMP_TXT
ACCESS PARAMETERS
(RECORDS
noLOGFILE
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY "'"
MISSING FIELD VALUES ARE NULL
)
LOCATION (DUMP_TXT:'input.csv')
)
REJECT LIMIT UNLIMITED;

I have created the directory pointing on 'C:\data'...And loaded a comma delimited CSV file in there...

- Checked the csv permissions ther are set to 'everyone'
- Checked the previladges of the directory, they are set to 'READ/WRITE'

But when I issue a select statement against the exte table I get an error '
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file input.csv in DUMP_TXT not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1'
Re: Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout [message #519431 is a reply to message #519428] Fri, 12 August 2011 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DIRECTORY object points to a directory on a database server (not your local disk). Is that the issue?
Re: Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout [message #519433 is a reply to message #519431] Fri, 12 August 2011 02:19 Go to previous messageGo to next message
gilbert_makinana
Messages: 5
Registered: August 2011
Location: CAPE TOWN
Junior Member

No the directory is pointing to my local disk..here is the script I used for creating it...'
CREATE OR REPLACE DIRECTORY
DUMP_TXT AS
'C:\data';

GRANT READ, WRITE ON DIRECTORY SYS.DUMP_TXT TO SUPP_GIM WITH GRANT OPTION;
Re: Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout [message #519435 is a reply to message #519433] Fri, 12 August 2011 02:30 Go to previous message
Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You misunderstood what I said: DIRECTORY *must* point to a directory on a database server, not on your PC (unless you run a database on your PC, of course).
Previous Topic: Decode with between clause...
Next Topic: UTL_FILE.put_line
Goto Forum:
  


Current Time: Sat Aug 09 19:32:40 CDT 2025