Database Link

How to Resolve ORA-01017 in Database Links

by Ed Chen
December 21, 2019January 21, 2020

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 Use GLOBAL_NAMES for Database Links

by Ed Chen
July 2, 2019November 29, 2019

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 »

DB Link, How and Why

by Ed Chen
March 30, 2019October 24, 2019

What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »

Can We Create Database Links for Another Schema?

by Ed Chen
July 27, 2018October 24, 2019

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 »

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

by Ed Chen
December 19, 2016August 15, 2019
2 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 »