-- Create database link
create public database link <DBLink名称> connect to <被连接库的用户名> identified by <被连接库的密码> using '<Oracle客户端工具建立的指向被连接库服务名>';
即 :
create public database link DBLink名称 connect to <被连接库的用户名> IDENTIFIED BY <被连接库的密码>
using '( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = (PROTOCOL = TCP)
(HOST = link的DB IP地址)
(PORT = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = 数据库服务名)
)
)';
quit;
eg. create public database link XMDS_KF connect to XMDS identified by XNDS using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 145.24.16.188)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XMDS)
)
)';
create public database link <DBLink名称> connect to <被连接库的用户名> identified by <被连接库的密码> using '<Oracle客户端工具建立的指向被连接库服务名>';
即 :
create public database link DBLink名称 connect to <被连接库的用户名> IDENTIFIED BY <被连接库的密码>
using '( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = (PROTOCOL = TCP)
(HOST = link的DB IP地址)
(PORT = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = 数据库服务名)
)
)';
quit;
eg. create public database link XMDS_KF connect to XMDS identified by XNDS using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 145.24.16.188)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XMDS)
)
)';