是这样的
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
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
Parameter type Boolean
Default value false
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values true | false
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects.If the value of GLOBAL_NAMES is false, then no check is performed. If you use or plan to use distributed processing, then Oracle recommends that you set this parameter to true to ensure the use of consistent naming conventions for databases and links in a networked environment.