1、使用语句创建DBLink:
create database link 要创建的dblink名称
connect to 要连接数据库的用户名 identified by 要连接数据的密码
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 连接数据库主机IP地址)(PORT = 端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = 连接数据库服务名)
)
)';
2、查询现有DBLINK
select * from ALL_DB_LINKS;
3、查询数据
select * from 表名@dblink名称