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

I got ” ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB already exists ” error in Oracle database.

 

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

Details of error are as follows.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31637: cannot create job MSDB_EXPORT for user SYS
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.KUPV$FT", line 1744
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 1099
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 2002
ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_4 already exists
ORA-06512: at "SYS.DBMS_AQADM", line 415
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3491
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4059
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3656
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3469
ORA-06512: at "SYS.DBMS_AQADM", line 406
ORA-06512: at "SYS.KUPC$QUE_INT", line 1928
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 493
ORA-06512: at "SYS.KUPV$FT_INT", line 981
ORA-06512: at "SYS.KUPV$FT", line 1646
ORA-06512: at "SYS.KUPV$FT", line 1103

 

 

This ORA-10635 error is related with the SYS.KUPC$DATAPUMP_QUETAB_4 AQ queue not having been cleaned up correctly from a previous Datapump job.

 

To solve this error, perform the following steps.

In most cases you should be able to resolve these errors by manually cleaning up the problem AQ queue (SYS.KUPC$DATAPUMP_QUETAB_1), by executing the following:

1. Perform the steps given in Note:336014.1 to ensure there are no orphaned datapump jobs.

2. Ensure that the STREAMS_POOL_SIZE parameter is set to at least 100M in the instance, e.g.:

connect / as sysdba
show parameter streams_pool_size;

3. Manually drop the problem queue table (SYS.KUPC$DATAPUMP_QUETAB_1), using:

connect / as sysdba
exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_1', force => TRUE, auto_commit => TRUE);

Note: There could be more than one queue table, examples: SYS.KUPC$DATAPUMP_QUETAB_2.

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )