How to create an Oracle DB link ?

From a database X, we wish to display a view located in another database Y.

In the Y database:

CREATE OR REPLACE FORCE EDITIONABLE VIEW "MY_VIEW" ("CustomerName", "ContactName") AS 
  SELECT 
    C.CUSTOMERNAME AS CustomerName,
    C.CONTACTNAME AS ContactName
  FROM
    CUSTOMER C;

In the X database:

CREATE PUBLIC DATABASE LINK MY_DB_LINK_TO_Y CONNECT TO <remoteuser> IDENTIFIED BY "<password>" USING 'db_y.domain.lan:1521/<SID>';

Access the remote view through the DB link :

select * from <myschema>."MY_VIEW" @MY_DB_LINK_TO_Y;

How to create an Oracle DB link ?

Enjoy Reading This Article?