同义词

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';