同义词
synonym,即对象别名alias
创建格式
grant create synonym to 用户;
create synonym 别名 for 对象;
例:
1、私有的同义词
create synonym table_name for 表;
create synonym shitu_name for 视图;
2、共有的同义词
create public synonym 别名 for 对象名;
删除别名
drop synonym 别名;
同义词访问顺序:
1、table or view exist ?
2、priv synonym exist ?
3、priv synonym object ?
4、public synonym exist ?
5、public synonym object ?
6、ORA-00942