Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External Table: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

vpolasaMay 15 2025 — edited May 15 2025

I'm trying to create an external table to read records from a csv file but seeing below error. What am I missing?

CREATE OR REPLACE DIRECTORY ext_dir_vpolasa AS 'C:\Users\vpolasa\Documents';

SELECT * 
  FROM all_tab_privs 
 WHERE table_name = 'EXT_DIR_VPOLASA';
 
 GRANTOR GRANTEE  TABLE_SCHEMA TABLE_NAME PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
 SYS	MYSCHEMA	SYS	EXT_DIR_VPOLASA	EXECUTE	YES	NO	NO	DIRECTORY	NO
 SYS	MYSCHEMA    SYS	EXT_DIR_VPOLASA	READ	YES	NO	NO	DIRECTORY	NO
 SYS	MYSCHEMA    SYS	EXT_DIR_VPOLASA	WRITE	YES	NO	NO	DIRECTORY	NO
 
 CREATE TABLE test_ext_vpolasa
 (
    last_name VARCHAR2(100)
 )
 ORGANIZATION EXTERNAL
 (
     TYPE oracle_loader
     DEFAULT DIRECTORY ext_dir_vpolasa
     ACCESS PARAMETERS 
     (
         RECORDS DELIMITED BY NEWLINE
         BADFILE ext_dir_vpolasa:'ext_test.bad'
         LOGFILE ext_dir_vpolasa:'ext_test.log'
         FIELDS TERMINATED BY ','
         MISSING FIELD VALUES ARE NULL
         ( 
            last_name
         )
     )
     LOCATION (ext_dir_vpolasa:'ext_test.csv')
 )REJECT LIMIT UNLIMITED
 SELECT * FROM test_ext_vpolasa;
 
 ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file ext_test.csv in EXT_DIR_VPOLASA not found
29913. 00000 -  "error in executing %s callout"
*Cause:    The execution of the specified callout caused an error.
*Action:   Examine the error messages take appropriate action.
Content of ext_test.csv:

LAST_NAME 
BILL 
WILLIAMS 
HUGHES 

Working on 19c Production, Windows 10

This post has been answered by Paulzip on May 15 2025
Jump to Answer
Comments
Post Details
Added on May 15 2025
3 comments
248 views