MANAGE DATABASE LINK

A database link allows you to reference objects in a remote database. 

SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by scott;
User altered.
[oracle@pansoft104 u01]$ export ORACLE_SID=dot
[oracle@pansoft104 u01]$ . .bash_profile
[oracle@pansoft104 u01]$ sqlplus / as sysdba
SQL> create user pansoft identified by pansoft;
User created.
SQL> conn / as sysdba
Connected.
SQL> grant create database link to pansoft;
Grant succeeded.
SQL> grant create public database link to pansoft;
Grant succeeded.
SQL> conn pansoft/pansoft
Connected.
SQL> create database link priv_moniter connect to scott identified by scott using 'tns_ben';
SQL> create database link pub_moniter connect to scott identified by scott using 'tns_ben';
Database link created.
SQL> select * from tab@pub_moniter;
TNAME       TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS       TABLE
DEPT       TABLE
EMP       TABLE
SALGRADE       TABLE
SQL> select * from user_db_links;
DB_LINK
--------------------------------------------------------------------------------
USERNAME       PASSWORD
------------------------------ ------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
---------
PRIV_MONITER
SCOTT
tns_ben
28-OCT-16

DB_LINK
--------------------------------------------------------------------------------
USERNAME       PASSWORD
------------------------------ ------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
---------
PUB_MONITER
SCOTT
tns_ben
28-OCT-16

SQL> select * from tab@priv_moniter;
TNAME       TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS       TABLE
DEPT       TABLE
EMP       TABLE
SALGRADE       TABLE
conn jin/jin
Connected.
SQL> select * from tab;
no rows selected
SQL> create table emp (emid number,emname varchar(23));
Table created.
SQL> select * from tab;
TNAME       TABTYPE CLUSTERID
------------------------------ ------- ----------
EMP       TABLE
SQL> insert into emp values (12,'adeeb');
1 row created.
SQL> conn pansoft/pansoft
Connected.
SQL> create database link emp connect to jin identified by jin using 'tns_ben';
Database link created.
SQL> select * from tab@emp;
TNAME       TABTYPE CLUSTERID
------------------------------ ------- ----------
EMP       TABLE
SQL> insert into emp values (12,'adeeb');
1 row created.
SQL> select * from emp;
      EMID EMNAME
---------- -----------------------
12 adeeb