CREATE PUBLIC DATABASE LINK <link_name>
CONNECT TO CURRENT_USER IDENTIFIED BY PASSWORD USING 'connect string';
E.g.
CREATE PUBLIC DATABASE LINK "DB1_LINK"
CONNECT TO USER IDENTIFIED BY PASSWORD USING 'DB1';
To verify that the database link is working:
SELECT sysdate FROM dual@DB1_LINK;
The above should return the current database system date.
Code: Select all
SYSDATE
---------
31-JAN-12