system同义词导致expdp错误

####使用expdp报错

expdp system/oracle logfile=106exp.log1 dumpfile=exp106_%U.dmp directory=expdir full=y parallel=8  ;

expdp system/oracle logfile=106exp.log1 dumpfile=exp106_%U.dmp directory=expdir full=y parallel=4 COMPRESSION=all ;
SQL> ho expdp system/oracle logfile=106exp.log1 dumpfile=exp106_%U.dmp directory=expdir full=y parallel=8 ;

Export: Release 11.2.0.4.0 - Production on Thu Nov 26 16:27:13 2020

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_02 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1840
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQADM_SYS
ORA-01775: looping chain of synonyms
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

一、删除同义词
drop public  synonym SYSTEM;

二、清理quene表
exec dbms_aqadm.drop_queue_table(queue_table =>'SYS.KUPC$DATAPUMP_QUETAB',force=> TRUE);

三、重建quene表
BEGIN
dbms_aqadm.create_queue_table(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB',
multiple_consumers => TRUE,
queue_payload_type =>'SYS.KUPC$_MESSAGE',
comment => 'DataPump Queue Table',
compatible=>'8.1.3');
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE = -24001 THEN NULL;
ELSE RAISE;
END IF;
END;

四、重新编译
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql