External Tables on Windows
243661Jul 26 2004 — edited Oct 4 2005I have Oracle loaded on a Unix server. I am trying to execute stored procedures using External Tables. My external table directories reside on a Windows OS. While I was successful in creating the external tables and the logical directories mapped to the OS drectory, I was not able to execute the procedure. It came up with errors.
I have the necessary grants on these directories.
The procedures runs successfully if the directories are created on the Unix box
14:41:21 Start Executing PL/SQL block ...
14:41:21 Starting execution of PL/SQL block...
Error -29913: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file exttbl_1970284.log
OS error No such file or directory
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
14:41:21 Execution failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
14:41:21 ORA-29400: data cartridge error
14:41:21 KUP-04063: unable to open log file invpbl_1970284.log
14:41:21 OS error No such file or directory
14:41:21 ORA-06512: at line 7
14:41:21 End Executing PL/SQL block
I have checked the read/write permissions on the Windows folder and they have full access
It is critical for me to make it work on a Windows platform