ORA-01775: looping chain of synonyms

今天使用expdp导出一个schema报错 ：ORA-01775: looping chain of synonyms

怀疑是对象删除但是同义词还遗留的原因，查询一下果然是

select 'drop public synonyms '||synonym_name||' ;' from dba_synonyms where table_owner=upper('ivasdata') and synonym_name not in (select object_name from dba_objects where owner=upper('ivasdata'));

'DROPPUBLICSYNONYMS'||SYNONYM_NAME||';'
-----------------------------------------------------
drop public synonyms SYS_EXPORT_SCHEMA_01 ;

删除多余的同义词

> drop public synonym SYS_EXPORT_SCHEMA_01 ;

Synonym dropped.

在执行导出，成功执行。