Database Link

How to Use GLOBAL_NAMES for Database Links

Posted on
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 going to very clearly. But what if we are in a complicated distributed environment, how to prevent connecting to the wrong destination? In such situation, Oracle recommends to turn on […]
Database Link

DB Link, How and Why

Posted on
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 a remote database. For better understanding the features of a database link which may play an important role in data migration, we should study what a database link can and […]