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.