Oracle Error Message
ORA-30647: error retrieving access parameters for external table string.string
Reason for the Error
an error occurred when fetching the access parameters for the specified external table.
Solution
If the access parameter is a query which returns a CLOB, check EXTERNAL_TAB$ to make sure the query is correct.