Schema list is incomplete when using Oracle ODBC driver from instant client. There is no way to select the correct schema who owns a database link; hence, the query fails with:
[Oracle][ODBC][Ora]ORA-02019: connection description for remote database not found
Product defect.
WORKAROUND 1
Run the following statement prior to running the query containing the database link:
alter session set current_schema=<DB_LINK owner>;
WORKAROUND 2
Install a full Oracle client and configure TDA to use it.
STATUS
Waiting for fix in a future release of Toad for Data Analysts.
