1. 建立 database link
create public database link xiehongwei
connect to xhw identified by xhw
using '(description = (address_list = (address = (protocol = tcp)(host = 127.0.0.1)(port = 1521)))
(connect_data = (service_name = orcl)))'
链接名称: xiehongwei
目标库信息(账户: xhw/ xhw,主机:127.0.0.1,端口:1521,实例:orcl )
2.测试
select * from t_user@xiehongwei
查询的时候可能报错误
:ORA-22992: 无法使用从远程表选择的 LOB 定位器
这是因为表中可能包含大字段CLOB或者BLOB。