检查其他表、视图、函数等有无重复定义过同义词
select *
from all_synonyms
where table_owner = 'HD40'
and synonym_name not like '%/%' and SYNONYM_name LIKE '%VENDORAPPLY%'
and table_name not in (
select object_name from user_objects
where object_type in ( -- 定义不在查询范围内的Type
'TABLE', 'VIEW', 'SEQUENCE',
'PROCEDURE', 'FUNCTION', 'TYPE'
)
);
如果是创建包体,检查包体中引用的函数、其他包头定义的公共方法是否有被定义
如果在包体中用了其他包的包头的方法,且这个包头并未被定义,也会出现循环同义词链
标签:定义,chain,looping,01775,synonyms,包头,包体,name From: https://www.cnblogs.com/jy00/p/17701890.html