Oracle Create a Database Link

1.Create a Database Link

-The database link is used to link two database together

 

CREATE DATABASE LINK OldToNew
CONNECT TO fel IDENTIFIED BY fel
USING ‘//192.168.1.128:1521/FEL’;
COMMIT;

 

-The user account and the URL are the one of the destination DB that we want to connect to

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.