今天使用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.
在执行导出,成功执行。