關鍵字：Oracle 數據庫
方法2：
如果沒有權限修改tnsnames.ora，那么就沒有辦法建立到adb數據庫的tns別名，那么就只能采用在創建dblink的時候，全寫解析符號。創建dblink的方法如下：
create database link
connect to bdb identified by identified by bdb
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.9.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbtestb)
)
)';
創建好tns別名之后，可以采用sqlplus username/password@tnsname來測試創建的tns別名是否正確。
我在生產系統中創建的一個dblink示例：
create database link NEW_DBLINK
connect to AIIPS identified by "1qaz2wsx"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.193.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zjpub)
)
)';
延伸閱讀
文章來源于領測軟件測試網 http://www.kjueaiud.com/
