[重慶思莊每日技術分享]-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)