Archive for the ‘verify external file for external table’ 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.