2014-06-08 Created By BaoXinjian

一、總結

---

1. 建立數據庫連接的方式

2. 查詢方式

3. 連接類型

4. 常用的查詢

?

二、具體分析

---

1. 建立數據庫連接的方式

????(1).使用tns進行建立

????????????????CREATE DATABASE LINK linkname

??????????????????? CONNECT TO user_name IDENTIFIED BY password

?????????????????? ?USING tns_dbname?

????(2).直接建立

????????????????CREATE DATABASE LINK linkname

?????????????????????CONNECT TO user_nameIDENTIFIED BY password

????????????????????USING '(DESCRIPTION =

???????????????????????????????????????????(ADDRESS_LIST =

????????????????????????????????????????????????????(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))

????????????????????????????????????????????)

????????????????????????????????????????????(CONNECT_DATA =

?????????????????????????????????????????????????? ?(SERVICE_NAME = dbname)

????????????????????????????????????????????)

?????????????????????????????????)'????

?

2. 查詢方式

????(1).直接使用select * form tablename@dblink????

????(2).建立同義詞，按同義詞方式進行查詢

????(3).建立物化視圖，提高執行效率

????????create public synonym syn_name for tablename@linknam

?

3. 連接類型

????(1).私有Private

????(2).共有Public

????????建立共有的數據庫連接時必須是有sysadmin和sys賬戶

????????????????CREATE PUBLIC DATABASE LINK linkname

????????????????????CONNECT TO user_name IDENTIFIED BY password

????????????????????USING tns_dbname

?

4. 常用的查詢

????(1).查詢當前賬戶所有的dblink連接

????????????????select * from user_db_links;?

????(2).查詢當前系統所有的dblink連接

????????????????select * from dba_db_links??

????(3).查詢當前正在連接的dblink連接

????????????????select * from v$dblink

?

Thanks and Regards

轉載于:https://www.cnblogs.com/eastsea/p/3776603.html

總結

以上是生活随笔為你收集整理的PLSQL_Database Link的基本概念和用法（概念）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。