What GLOBAL_NAMES do to DB Linksby Ed ChenJuly 2, 2019September 27, 2021GLOBAL_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, 2016September 30, 20212 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