ORA-02082

How to Resolve ORA-02082: a loopback database link must have a connection qualifier

by Ed Chen
April 22, 2017May 10, 2018
2 Comments

ORA-02082 When I tried to create a database link, it threw ORA-02082. SQL> create public database link BOSTON connect to SCOTT identified by SCOTT using… Read More »

How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE

by Ed Chen
December 19, 2016December 11, 2022
4 Comments

ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link;… Read More »