结合平日的经验,现总结几种创建dblink的方法:
(1) 最常用的方法:
create database link dblink_120
connect to zhan identified by “zhan”
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.120)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = bond)))’;
(2) 利用tns的方法:
首先我们在服务端添加tns,注意这里一定是目标库服务端的tnsnames.ora下面添加,不是在客户端的tnsnames.ora下添加,否则会报错。
db_110 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(ERVICE_NAME = orcl)
)
)
db_120 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.120)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bond)
)
)
然后再创建dblink:
create database link dblink_120 connect to zhan identified by “zhan” using ‘db_120’;
(3) 利用host:port/sid的方式:
create database link dblink_120 connect to zhan identified by “zhan” using ‘192.168.50.120:1521/bond’;
删除dblink方法:
drop database link dblink_120;
小结
这三种方式都可以实现dblink的创建,同样的功能,可能有多种实现方法,需要我们去细心发现和总结。