1、create synonym 目标库表名 for 原库.要同义词的表名@数据库的serviceName;
例如:create synonym t_photo for ECARDV5.T_PHOTO@yktdbpdb;
其他sql
1、查看
SELECT * FROM SYS.ALL_SYNONYMS t WHERE t.owner in ('DOOR');//其中DOOR表示库的当前登录人
select * from dba_synonyms;
select * from dba_db_links;