使用tnsname.ora创建dblink:
create database link linktest
connect to TEST IDENTIFIED BY "aaa"
using 'orcl';
创建成功查询时报如下错误:
直接使用ip地址创建:
CREATE DATABASE LINK linktest
connect to TEST
IDENTIFIED BY "aaa"
USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 170.17.7.190) (PORT = 1526))) (CONNECT_DATA = (SERVICE_NAME = TESTDB)))';
创建以后查询:
可以正常使用,现在还不知道是为什么