I have Toad for Oracle 188.8.131.52 on a Windows 7 pc. I have a select on a table in a different Oracle database by using a db-link. WHen I execute this statement with ctrl+CR or F9 I get an error message: “ORA-02019: connection description for remote database not found”. When I execute this as a script (F5) the sql executes ok. Anyone knows what is wrong?
I need how to call table one database to another database.
Please help me to anyone…
I also get “ORA-02019: connection description for remote database not found” on Toad for Oracle 184.108.40.206 Xpert Edition running on Windows 7 x64. How is the SQL (or PL/SQL) window executing the query differently than the script feature? I also have this problem when creating a DBLink.
Found the resolution at https://support.quest.com/toad-for-oracle/kb/64146
A Default Schema had been set in the Toad Options for all users logging into that database instance and that schema did not own the database link being used.