HOW TO CREATE AND DROP DATABASE LINK

Below is the syntax for creating and dropping DB Link in Oracle

Enter the DB Link Name, username, Password and Schema Name in the below syntax

Note: Schema Name should be in Quotes and you should have sufficient privileges to create and drop DB Link.

CREATE DATABASE LINK
DBLINKNAME 
CONNECT TO USER
IDENTIFIED BY PASSWORD
USING 'SCHEMA NAME';



DROP DATABASE LINK DBLINKNAME ;