CREATE DATABASE LINK dblink_name
CONNECT TO remote_username
IDENTIFIED BY remote_password
USING 'tns_service_name';
The remote DB will then be accessible in the following way:
SELECT * FROM MY_TABLE@dblink_name;
To test a database link connection without needing to know any of the objec...
Let we assume we have two databases "ORA1" and "ORA2". We can access the objects of "ORA2" from database "ORA1" using a database link.
Prerequisites:
For creating a private Database link you need a CREATE DATABASE LINK privilege.
For creating a private Data...
