CREATE TABLE XX_Lookup_EXT
(
LOOKUP_TYPE varchar2(200),
LOOKUP_CODE varchar2(200),
MEANING varchar2(200),
ENABLED_FLAG varchar2(10)
)
ORGANIZATION EXTERNAL
  (  TYPE ORACLE_LOADER
     DEFAULT DIRECTORY INTF_DIR1
     ACCESS PARAMETERS 
       ( RECORDS DELIMITED BY NEWLINE SKIP 1
         NODISCARDFILE
         FIELDS TERMINATED BY '|'
         OPTIONALLY ENCLOSED BY '"'
         MISSING FIELD VALUES ARE NULL
         REJECT ROWS WITH ALL NULL FIELDS
            )
     LOCATION (INTF_DIR1:'LOOKUP_CODE.csv')
  )
REJECT LIMIT UNLIMITED
NOPARALLEL
nomonitoring;

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /orabin/tst/test/XX_LOOKUP_EXT_30723.log
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.

SQL> CREATE TABLE XX_Lookup_EXT
  2  (
  3  LOOKUP_TYPE varchar2(200),
  4  LOOKUP_CODE varchar2(200),
  5  MEANING varchar2(200),
  6  ENABLED_FLAG varchar2(10)
  7  )
  8  ORGANIZATION EXTERNAL
  9    (  TYPE ORACLE_LOADER
 10       DEFAULT DIRECTORY INTF_DIR1
 11       ACCESS PARAMETERS
 12         ( RECORDS DELIMITED BY NEWLINE SKIP 1
 13           NODISCARDFILE
 14           FIELDS TERMINATED BY '|'
 15           OPTIONALLY ENCLOSED BY '"'
 16           MISSING FIELD VALUES ARE NULL
 17           REJECT ROWS WITH ALL NULL FIELDS
 18              )
 19       LOCATION (INTF_DIR1:'LOOKUP_CODE.csv')
 20    )
 21  REJECT LIMIT UNLIMITED
 22  NOPARALLEL
 23  nomonitoring;

Table created.