Oracle expdp ORA-01775: looping chain of synonyms 解决办法

郑全

expdp时报错：
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms

解决方法：删除SYS_EXPORT_SCHEMA_* 相关的同义词。


SQL> select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXPORT_SCHEMA_%' and


OBJECT_TYPE='SYNONYM';


OWNER                          OBJECT_NAME          OBJECT_TYPE         STATUS
------------------------------ -------------------- ------------------- -------
PUBLIC                         SYS_EXPORT_SCHEMA_01 SYNONYM             VALID
PUBLIC                         SYS_EXPORT_SCHEMA_02 SYNONYM             INVALID
PUBLIC                         SYS_EXPORT_SCHEMA_03 SYNONYM             INVALID


SQL> drop public synonym SYS_EXPORT_SCHEMA_01;


Synonym dropped.


SQL> drop public synonym SYS_EXPORT_SCHEMA_02;


Synonym dropped.


SQL>  drop public synonym SYS_EXPORT_SCHEMA_03 ;


Synonym dropped.



再去导出，就可以了。


参考文档：
DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms (Doc ID 459151.1)