This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 折腾死我了，External table 问题有偿求助。 同时感慨一下，oracle的东西有时就是弱智：要求从UNC location读一个text文件，windows环境. 有兴趣PM我，我提供配置细节.
error message is:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04001: error opening file \\xx.xx.xx.xx\f$\tmp\test.txt
ORA-06512: at "SYS.ORACLE_LOADER", line 52
ORA-06512: at line 1
while I can see there is log file generated for UNC testing with following message:
KUP-04001: error opening file \\xx.xx.xx.xx\tmp\test.txt
KUP-04017: OS message: The data is invalid.
-alan_wang99(落花....流水....);
2010-1-6
{510}
(#5785118@0)
-
把数据文件弄到本地（就是ORACLE所在主机）还会出错吗？
-newkid(newkid);
2010-1-6
(#5785574@0)
-
just a guess: if you are accessing the file from within a StoredProcedure, you may not have enough privilege to access the file, may need to configure Kerbrose
-secondlasttry(镀锌铁瓦);
2010-1-6
(#5785632@0)
-
你没有在数据字典里 创建 directory 吧
-vetra(豆泡果 之 多泡泡);
2010-1-6
(#5785651@0)
-
Most likely your text file is corrupted or ill-formatted as I guess
-renjl0810(相信网络,相信Google);
2010-1-6
(#5785657@0)
-
感谢各位的解答， 同时也澄清一些疑虑: 1. 数据绝对正确， 在server上读过，external table没问题, 2, 也创建了directories, 本地的和UNC的, 本地的工作正常, 3. 我只是从sqlplus中读external table
-alan_wang99(落花....流水....);
2010-1-7
(#5787144@0)