ORA-01017 in Database Links Before troubleshooting error ORA-01017, please make sure that every portion of connection string that you provided is correct. Let's me show… Read More »How to Resolve ORA-01017 in Database Links
GLOBAL_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 »How to Use GLOBAL_NAMES for Database Links
The answer is no. You can see the reason why we can't create database links for another user in this post. Prerequisites for Creating Database… Read More »Can We Create Database Links for Another Schema?
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 »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE