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

What DB Link Can and Cannot Do

Posted on
Can and Cannot 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 cannot do in a distributed database system in order to develop our data migration strategy. Generally speaking, you can perform Data Query Language (DQL) and […]
Database Link

Can We Create Database Links for Another Schema?

Posted on
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 Links Before proceeding any further, you have to make sure the users involving in the database link have been granted proper system privileges: Grant CREATE DATABASE LINK or CREATE PUBLIC […]