ORA-39001 ORA-01775: looping chain of synonyms解决方法

 

小生有约10:55:37

oracle-> impdp newweb/newweb directory=dump_dir dumpfile=newweb_dp.dmp logfile=newweb_impdp.log schemas=newweb

Import: Release 10.2.0.4.0 - 64bit Production on Thursday, 07 January, 2010 10:32:57

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms

 

棉花糖ONE10:55:59
errorstack跟踪下看看

 

棉花糖ONE11:01:24
drop public synonym sys_import_schema_01;

 

棉花糖ONE11:01:30
再导入

ID 459151.1

 

小生有约 16:39:02
棉花兄，上午那个问题，把drop public synonym sys_import_schema_01;就可以了