I used expdp to export a schema from 11g. I am attempting to use impdp to import that schema into 12c. I am getting this result:
ORA-31626: job does not exist
ORA-21637: cannot create job SYS_IMPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 810
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 1898
ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_1 already exists
Running this:
EXECUTE dbms_aqadm.drop_queue_table ( queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_1');
Returns this:
ORA-24002: QUEUE_TABLE SYS.KUPC$DATAPUMP_QUETAB_1 does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 388
ORA-06512: at line 1
24002. 00000 - "QUEUE_TABLE %s does not exist"
*Cause: Queue_table not exist.
*Action: Query on the user view USER_QUEUE_TABLES to find out existing queue tables.
So I did that:
SELECT * FROM USER_QUEUE_TABLES;
Returns this:
QUEUE_TABLE TYPE OBJECT_TYPE
================= ====== ============
ALERT_QT OBJECT SYS.ALERT_TYPE
AQ$_MEM_MC RAW
AQ_EVENT_TABLE OBJECT SYS.AQ$_EVENT_MESSAGE
AQ_PROP_TABLE OBJECT SYS.AQ$_NOTIFY_MSG
KUPC$DATAPUMP_QUETAB OBJECT SYS.KUPC$_MESSAGE
SCHEDULER$_EVENT_QTAB OBJECT SYS.SCHEDULER$_EVENT_INFO
SCHEDULER$_REMDB_JOBQTAB OBJECT SYS.SCHEDULER$_REMOTE_DB_JOB_INFO
SCHEDULER_FILEWATCHER_QT OBJECT SYS.SCHEDULER_FILEWATCHER_RESULT
SYS$SERVICE_METRICS_TAB OBJECT SYS.SYS$RLBTYP
So it appears that there is a KUPC$DATAPUMP_QUETAB, but not a KUPC$DATAPUMP_QUETAB_1. I also tried deleting KUPC$DATAPUMP_QUETAB using this command:
EXECUTE dbms_aqadm.drop_queue_table ( queue_table => 'SYS.KUPC$DATAPUMP_QUETAB', FORCE => TRUE);
Which returns this:
Error report:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_AQADM", line 388
ORA-06512: at line 1
01422. 00000 - "exact fetch returns more than requested number of rows"
*Cause: The number specified in exact fetch is less than the rows returned.
*Action: Rewrite the query or change number of rows requested
What should I try next?