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)