Archive for the ‘Oracle external tables’ tag
How to avoid errors when querying external tables
Somebody got to my blog searching for how to find an external file. I thought about why they might be looking for that. Since the lack of a file raises an error stack, I concluded that they want to verify whether the file exists before querying it. That way, they avoid the annoying ORA-29913, ORA-29400, and KUP-04040 error stack.
I’ve added a page to describe the complete set of steps … The instructions let you avoid the error stack by verifying the existence of the file first.
Subscribe via RSS