Error ORA-01775: looping chain of synonyms when export

C:\Documents and Settings\nai3119>expdp ‘/ as sysdba’ DIRECTORY=DMPDIR schemas=DOW_USER DUMPFILE=JVL

Export: Release – Production on Fri Feb 10 06:06:30 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Automatic Storage Management, Oracle Label Security, OLAP, Oracle Database Vault
and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms


solution: query in database with below sql,

SELECT owner, object_name, object_type, status from dba_objects where object_name like ‘%SYS_EXPORT%’;

if you get a record like with type SYNONYM

OWNER                     OBJECT_NAME                  OBJECT_TYPE         STATUS
————————- —————————- ——————- ——-
PUBLIC                    SYS_EXPORT_SCHEMA_01         SYNONYM             VALID 

drop this SYNONYM manually,


and try the export again.


Reason: Oracle will create a SYNONYM for datapump job when the job starts, once the job completes successfully the SYNONYM will be dropped as well, but if the job fails, the SYNONYM be dropped and you will get above error message.



0 条评论。


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>