How to re-create the SYS.KUPC$DATAPUMP_QUETAB_1
By wrong understanding, I executed the following SQL.
exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_1', force => TRUE, auto_commit => TRUE);
exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_1', force => TRUE, auto_commit => TRUE);
Now impdp running into fail..
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user IPSIFRSPRD
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-01403: no data found
0