'external table error ora-29913 on just one table
I'm getting an ora-29913 external table error. Error opening file /usr/app/xyz/abc.txt. The uniqueness behind this we have 15 other external tables all referring to same directory path. But the problem is only occurring with just one external table. I checked the table all_tab_privs for privileges for the table which is getting error and a good external table, and I don't see any permission issue there. Earlier the file was ftp'ed. Now its sent via Sftp. Could that be the issue? Please assist.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|