ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_1 already

ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_1 already

1、查询无效对象

SQL>select object_name from all_objects where owner='SYS' and status='INVALID';

OBJECT_NAME

------------------------------

KUPC$DATAPUMP_QUETAB_1

SYSNTfVzZ/2KLQNTgQ8CoAAJA1A==

SYSNTfVzZ/2KNQNTgQ8CoAAJA1A==

SYSNTfVzZ/2KPQNTgQ8CoAAJA1A==

AQ$_KUPC$DATAPUMP_QUETAB_V

AQ$_KUPC$DATAPUMP_QUETAB_E

AQ$_KUPC$DATAPUMP_QUETAB_F

AQ$KUPC$DATAPUMP_QUETAB

SBF_PUBLIC

无效对象中有datapump组件

2、删除datapump queue表

SQL>exec dbms_aqadm.drop_queue_table(queue_table =>'KUPC$DATAPUMP_QUETAB_2', force=> TRUE);

3、编译无效对象

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

4、检查无效组件

SQL>select object_name from all_objects where owner='SYS' and status='INVALID';

5、到此没有无效组件，如果有，重启实例，继续报错

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-01403: no data found

ORA-39097: Data Pump job encountered unexpected error 100

6、执行

SQL>@$ORACLE_HOME/rdbms/admin/catmet2.sql