废话不多说直接上SQL语句:
create database link linkname
connect to dbuser identified by dbpassword
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.122.110)(PORT = 1521))
)
(CONNECT_DA
(SERVICE_NAME = rac)
)
)';
其中 linkname 是数据链名称 ,dbuser 登陆用户名 ,dbpassword 登陆密码 ,HOST= 数据库所在ip,PORT =端口(默认是1521),SERVICE_NAME=数据库的sid(一般默认是orcl)
获取数据库的sid:select instance_name from v$instance
例子:
create database link interfaceDb_8_11
connect to interfaceDb identified by 000000
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';