Oracle Error ORA-30647: error retrieving access parameters for external table string.string

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.