Error ORA-01775: looping chain of synonyms when export

C:\Documents and Settings\nai3119>expdp ‘/ as sysdba’ DIRECTORY=DMPDIR schemas=DOW_USER DUMPFILE=JVL
PS04P_RELEASE31_EXP0211.DMP LOGFILE=JVLPS04P_RELEASE31_EXP0211.LOG

Export: Release 11.2.0.2.0 – 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 11.2.0.2.0 – 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,

DROP PUBLIC SYNONYM SYS_EXPORT_SCHEMA_01 ;

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>