Oracle 9i External Table error - ORA-29913: error in executing ODCIEXTTABLEOPEN callout [message #519428] |
Fri, 12 August 2011 02:04  |
|
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'
|
|
|
|
|
|