expdp ORA-01775: looping chain of synonyms 解決辦法

lovehewenyu發表於2014-10-23
OOPAI


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.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@PreProDB ~]$ expdp system/system


Export: Release 11.2.0.3.0 - Production on Thu Oct 23 15:40:12 2014


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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26442936/viewspace-1308143/，如需轉載，請註明出處，否則將追究法律責任。

相關文章