What GLOBAL_NAMES do to DB Linksby Ed ChenJuly 2, 2019December 10, 2022GLOBAL_NAMES Normally, we turned off GLOBAL_NAMES to prevent additional check on remote database before connecting to it. This is because we know where we are… Read More »What GLOBAL_NAMES do to DB Links
How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASEby Ed ChenDecember 19, 2016May 18, 20234 CommentsORA-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 »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE