我是这样实现的,不知可不可行,望高手指点
CREATE DATABASE LINK ykhr CONNECT TO YKHR IDENTIFIED BY YKHR USING 'ORCL_192.168.0.3'CREATE SYNONYM DEPARTMENT FOR YKHR.DEPARTMENT@YKHRDABASE;
select * from department老是报错:tns:could not resolve service name
CREATE DATABASE LINK ykhr CONNECT TO YKHR IDENTIFIED BY YKHR USING 'ORCL_192.168.0.3'CREATE SYNONYM DEPARTMENT FOR YKHR.DEPARTMENT@YKHRDABASE;
select * from department老是报错:tns:could not resolve service name
select * from department
CSDN - 技术社区 - 问题
推荐给朋友 | 关闭窗口
主 题: 访问异地数据库的问题(望高手指点)
作 者: gucuixia20031979 ()
等 级:
信 誉 分: 100
人 气: 6
所属社区: Oracle 开发
问题点数: 20
回复次数: 1
发表时间: 2006-10-27 13:10:35
我是这样实现的,可是不可以
CREATE DATABASE LINK ykhr CONNECT TO YKHR IDENTIFIED BY YKHR USING 'ORCL_192.168.0.3'
CREATE SYNONYM DEPARTMENT FOR DEPARTMENT@Yykhr ;
select * from department
老是报错:tns:could not resolve service name
CREATE DATABASE LINK ykhr CONNECT TO YKHR IDENTIFIED BY YKHR USING 'ORCL_192.168.0.3'
CREATE SYNONYM DEPARTMENT FOR DEPARTMENT@ykhr ;
select * from department
老是报错:tns:could not resolve service name
select * from DEPARTMENT@ykhr;
http://community.csdn.net/Expert/topic/4844/4844025.xml?temp=.5531427