ITPub博客

首页 > 数据库 > Oracle > Oracle expdp ORA-01775: looping chain of synonyms 解决办法

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

原创 Oracle 作者:lovehewenyu 时间:2014-10-23 15:44:19 0 删除 编辑



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博客 ” ,链接:https://blog.itpub.net/26442936/viewspace-1308143/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
10年金融行业老鸟。Oracle,Mysql,PostgreSQL,EMC 存储,NBU备份。微信/电话 18211103995

注册时间:2012-02-03

  • 博文量
    307
  • 访问量
    1528515