同义词 和 DBlink 的相关SQL

drop database link m8_link;
create database link m8_link
--需修改下列数据库名和数据库实例
connect to tms identified by tms
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test100)
    )
 )';

 

D:\oracle\NETWORK\ADMIN\tnsnames.ora

test100表示实例名字

 

--先建立一个DBLink，然后新建同义词

--删除已有的同义词
drop synonym CM_M8_ACCOUNT;

 

--添加cmcs系统的同义词
CREATE SYNONYM CM_M8_ACCOUNT FOR CM_M8_ACCOUNT@m8_link;