<p>
When I try to read an external table I am getting the error
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error error opening file E:\OracleDB\FDRSDB\FDRSDB_Log\log_access_level_lookup.log
This file (and others similar to it) have been working for me for over a year. The problem seems to have started when I tried creating a new schema with the goal of being able to recreate the old schema by running script files and so forth. This process did include dropping the directory objects and creating them again from within the new schema. I changed this to using CREATE OR REPLACE after I realized I could do that instead but this did not happen until after trying the DROP then CREATE procedure first.
I have seen from previous questions that there may be a permissions problem but I checked those and the schema does have read and write privileges to the objects. The OS (Windows) file access permissions are also correct.
This is not a problem with a specific table; it is happening with all of the external files in the schema (similar to the following sample).
Oracle DB version is 11g running on Windows 2000.
Any ideas?
For what it's worth, the table and directory definitions are as follows:
CREATE TABLE ext_access_level_lookup
(
access_level VARCHAR2(7)
)
Organization external
( type oracle_loader
default directory FDRSDB_DUMP_DIR
access parameters
( recored delimited by newline
badfile fdrsdb_log_dir:bad_access_level_lookup
logfile fdrsdb-log_dir:log_access_level_lookup
fields terminate by ‘|'
rtrim
( access_level
)
)
Location (‘access_level_lookup.dmo')
)
Directories are:
</p>
<p>
FDRSDB_DUMP_DIR ‘E:\OracleDB\FDRSDB\FDRSDB_Dumps'
FDRSDB_LOG_DIR ‘E:\OracleDB\FDRSDB\FDRSDB_Log'
</p>
Edited by: user556531 on Oct 27, 2008 1:08 PM