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 […]