DataPump Export (EXPDP) Fails With Errors ORA-39080 ORA-24203 Queue Table SYS.KUPC$DATAPUMP_QUETAB Has Errors (Doc ID 1452735.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2013***

Symptoms

Full DataPump export fails with errors:

Export: Release 11.1.0.7.0 - 64bit Production on Wednesday, 25 April, 2012 8:45:23
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 736
ORA-39080: failed to create queues "KUPC$C_1_20120425084525" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1665
ORA-24203: operation failed, queue table SYS.KUPC$DATAPUMP_QUETAB has errors

Changes

Database was recently upgraded.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms