同义词

相关mysql视频教程推荐：《mysql教程》

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

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