Oracle Error KUP-11010: unable to open at least one dump file for fetch

Oracle Error Message

KUP-11010: unable to open at least one dump file for fetch

Reason for the Error

None of the files in the LOCATION clause can be opened for a fetch on an external table.

Solution

A fetch operation on an external table in SQL mode requires that at least one file could be opened. Check that the directory object and file names to the dump files are correct.