1、通过plsql创建
右键Database links 创建
name(links名称)
Username(关联库账号)
Password(关联库密码)
Database(关连库地址)
2、sql方式创建
备注:
DBLINK_test(links名)
other_db(连接库账号)
pwd(连接库密码)
HOST(连库IP)
PORT(连库端口)
create public database link DBLINK_test
connect to other_db IDENTIFIED BY pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
3、使用database links
select * from table1@xtbg
注意:@xtbg是database links的name