Hi all Guru's,

This is the first time i am using the external tables feature of
oracle 9i. I had created the external table,data directory, grant read
and write permission on data directory. I am able to do all above things
without any error. but when i execute selet query i receive following
error.

select count(*) from external_table
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file external_table.log
OS error No such file or directory
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

I check for the write permission at operating system level for the data
directory. I found everything is ok except one dought that the the flat
file should be resides on database server only???... Because in my
case my data directory path is of application server and my flat file is
resides on application server.

Can anyone help me to solve above error......

--
Regards
Dinesh Vanage



Oracle LazyDBA home page