Database Link of Oracle Database

Statement:

CREATE [PUBLIC] DATABASE LINK link
CONNECT TO username IDENTIFIED BY password
USING 'connectstring';

Query database link.

select * from dba_db_links;

Grant privileges.

grant create public database link, create database link to jove;

Sample:

create public database link to_source connect to jove identified by jove using '172.17.0.2:1521/orcl';

create database link to_source connect to jove identified by jove using 'tns_orcl';

create database link to_source connect to jove identified by jove
using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.0.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl))';

drop public database link to_source;