Oracle同义词

 一、在管理员账号下给cmsinf账户创建以下权限：
grant CREATE DATABASE LINK to user1;

grant PUBLIC DATABASE LINK to user1;
              
grant DROP PUBLIC DATABASE LINK to user1 ;

 二、创建与远程数据库之间的DB_Link
create database link DB_Link
  connect to gysx6test identified by gysxtest2016
  using '(DESCRIPTION =
                (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = linkIP)(PORT = 1521))
                )
                (CONNECT_DATA =
                  (SERVICE_NAME = linkServiceName)
                )
              )';

使用dblink例如：select * from tableName@linkName;

这里linkName自己定，linkUser和linkPwd就是我这里的数据库B的用户名、密码，linkIP是B所在服务器的ip，1521是默认端口不一样的直接改，然后是linkServiceName是服务名，这里如果是SID名，就换成SID_NAME=linkSIDName。

 三、用户级别同义词
 SELECT * FROM USER_SYNONYMS;
              
 四、创建同义词
create  synonym tableName for tableName @DB_Link;

 五、删除同义词             
drop  synonym tableName ;
                         
select *from tableName @DB_Link;
                           
select *from tableName ;