MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Archive for the ‘verify external file for external table’ tag

How to avoid errors when querying external tables

without comments

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.

Written by maclochlainn

September 28th, 2008 at 11:21 pm