oracle database link 應用

oracle database link 工作記錄
SQL> conn /as sysdba
Connected.
SQL> grant CREATE DATABASE LINK to doudou;
Grant succeeded.

SQL> conn doudou/doudou2013
Connected.
SQL> create database link doudou_133 connect to xiaoyu identified by xiaoyu2010 using 'doudou_133';
Database link created.

oracle database link 學習

1、許可權
private database link : CREATE DATABASE LINK system privilege.
public database link : CREATE PUBLIC DATABASE LINK system privilege.
remote oracle database: CREATE SESSION system privilege on the remote oracle database.
2、tnsnames.ora配置
DOUDOU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = doudou)
    )
  )
3、建立database link語法
private database link : create database link link_pv_doudou connect to doudou identified by oracle using 'doudou';
public database link : create public database link link_pu_doudou connect to doudou identified by oracle using 'doudou';

4、database link檢視 user_db_links、dba_db_links

5、刪除database link語法
private database link : drop database link link_pv_doudou;
public database link : drop public database link link_pu_doudou;

6、擴充
本地使用者會繼承遠端使用者的許可權，所以本地使用者想新增許可權，只需要新增遠端的許可權就可以了。