ORA-01775: looping chain of synonyms

E:\dbbak\expdp\scripts>E:\app\Administrator\product\11.2.0\dbhome_1\bin\expdp '/ as sysdba ' directory=backup dumpfile=zjlisdb_20260204.dmp COMPRESSION=DATA_ONLY  full=y logfile=expdp_zjlisdb_20260204.log

Export: Release 11.2.0.1.0 - Production on 星期三 2月 4 13:42:24 2026

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

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: 参数值无效
ORA-01775: 同义词的循环链

 解决方法:
 set linesize 400 pagesize 400
 col object_name for a35
 select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXP%';
 OWNER                          OBJECT_NAME                         OBJECT_TYPE         STATUS
------------------------------ ----------------------------------- ------------------- -------
SYS                            DBMS_AQ_SYS_EXP_INTERNAL            PACKAGE             VALID
SYS                            DBMS_AQ_SYS_EXP_ACTIONS             PACKAGE BODY        VALID
SYS                            DBMS_AQ_SYS_EXP_INTERNAL            PACKAGE BODY        VALID
SYS                            DBMS_AQ_SYS_EXP_ACTIONS             PACKAGE             VALID
PUBLIC                         DBMS_AQ_SYS_EXP_INTERNAL            SYNONYM             VALID
PUBLIC                         DBMS_AQ_SYS_EXP_ACTIONS             SYNONYM             VALID
PUBLIC                         SYS_EXPORT_FULL_12                  SYNONYM             INVALID
PUBLIC                         SYS_EXPORT_FULL_13                  SYNONYM             INVALID
PUBLIC                         SYS_EXPORT_FULL_01                  SYNONYM             VALID
DBBACKUP                       SYS_EXPORT_SCHEMA_01           TABLE               VALID

 
SQL> drop public synonym  SYS_EXPORT_FULL_01;

表已删除。


或者使用errorstack分析错误原因:
SQL> alter system set events='1775 trace name errorstack level 3';
 
 执行备份脚本:
E:\dbbak\expdp\scripts>E:\app\Administrator\product\11.2.0\dbhome_1\bin\expdp '/ as sysdba ' directory=backup dumpfile=zjlisdb_20260204.dmp COMPRESSION=DATA_ONLY  full=y logfile=expdp_zjlisdb_20260204.log
 
SQL> alter system set events='1775 trace name errorstack off';
 
SQL> select value from v$diag_info where name='Default Trace File';