1.创建：
-- Create the synonym
create or replace synonym CPS_ROLE_PERMISSION
for
CPSSYS.CPS_ROLE_PERMISSION@ORA11G@UCC_BICP;
2.查看
select * from all_objects t where t.owner like ‘LBI_%‘ AND T.OBJECT_TYPE LIKE ‘SY‘;
原文：http://www.cnblogs.com/gcczhongduan/p/4307477.html