I recently promoted my code from development to QA instance and I am getting the error when I try to read the external table from Toad in QA instance. I never got this error in development instance. Looks like the log files are not
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /export/home/camsdocq/meterwatch/rates_log.log
when I go to see I do not see any log or bad files
$ ls -ltr *.log
*.log: No such file or directory
$ pwd
/export/home/camsdocq/meterwatch
$ ls -ltr *.bad
*.bad: No such file or directory
$
Here is the script of the external table which works perfectly in development environment
DROP TABLE MWATCH.RATES_EXT CASCADE CONSTRAINTS;
CREATE TABLE MWATCH.RATES_EXT
(
RATE_CODE VARCHAR2(8 BYTE),
USAGE_CODE VARCHAR2(4 BYTE),
PEAK_CODE VARCHAR2(8 BYTE),
SQI VARCHAR2(8 BYTE),
FROM_DATE DATE,
TO__DATE VARCHAR2(10 BYTE),
RATE VARCHAR2(10 BYTE),
FROM_SYSTEM CHAR(4 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY METERWATCH
ACCESS PARAMETERS
( records delimited by newline
badfile "METERWATCH":'rates_bad' logfile "METERWATCH":'rates_log'
fields terminated by '|' missing field values are null
( RATE_CODE, USAGE_CODE, PEAK_CODE, SQI, FROM_DATE CHAR DATE_FORMAT DATE MASK "YYYY-MM-DD", TO__DATE , RATE , FROM_SYSTEM )
)
LOCATION (METERWATCH:'rates.dat')
)
REJECT LIMIT UNLIMITED
PARALLEL ( DEGREE 5 INSTANCES 1 )
NOMONITORING;