Oracle database link and synonym

 

 

create  database link WWMD_LINK
connect to WWMD_USER identified by GMME1PC
using 'CDWIT301'

查看已经定义的database link
select * from dba_db_links;这种方式可以查看到database link定义信息
select * from dba_objects where object_type like 'DATABASE LINK';

删除database link
drop [public] database link to234db;其中public 表示删除公有的database link;

 

 

create or replace  synonym WWMD_CUST_CHANL_GRP for idwit3.WWMD_CUST_CHANL_GRP

create or replace  synonym WWMD_CUST_CHANL_MAP for idwit3.WWMD_CUST_CHANL_MAP