IMPDP ERROR (ORA-31693 ORA-29913 ORA-04063 ORA-06512 ORA-06512 ORA-04088)

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

ORA-31693: Table data object "HR"."CD_CON" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-04063: queue "HR.HR_EVENT_Q" has errors

ORA-06512: at "SYS.DBMS_AQ", line 169

ORA-06512: at "HR.CD_CON_INS_UPD_TRIGGER", line 12

ORA-04088: error during execution of trigger 'HR.CD_CON_INS_UPD_TRIGGER'

select count(*) from HR.CD_CON;

alter trigger HR.CD_CON_INS_UPD_TRIGGER disable;

impdp "'/ as sysdba'" tables=HR.CD_CON directory=PUMP dumpfile=dumpfile_exp_data.dmp  logfile=imp_data_cdc.log transform=storage:n TABLE_EXISTS_ACTION=APPEND

alter trigger HR.CD_CON_INS_UPD_TRIGGER enable;

select count(*) from HR.CD_CON;

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

ORA-31693: Table data object "HR"."TCDC_STATUS" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-04063: queue "HR.HR_EVENT_Q" has errors

ORA-06512: at "SYS.DBMS_AQ", line 169

ORA-06512: at "HR.CD_CON_INS_UPD_TRIGGER", line 12

ORA-04088: error during execution of trigger 'HR.CD_CON_INS_UPD_TRIGGER'

ORA-06512: at "HR.TCDC_STATUS_INS_UPD_TRIGGER", line 50

ORA-04088: error during execution of

select count(*) from HR.TCDC_STATUS;

alter trigger HR.CD_CON_INS_UPD_TRIGGER disable;

alter trigger HR.TCDC_STATUS_INS_UPD_TRIGGER disable;

impdp "'/ as sysdba'" tables=HR.TCDC_STATUS directory=PUMP dumpfile=dumpfile_exp_data.dmp  logfile=imp_data_cdc.log transform=storage:n TABLE_EXISTS_ACTION=APPEND

alter trigger HR.CD_CON_INS_UPD_TRIGGER enable;

alter trigger HR.TCDC_STATUS_INS_UPD_TRIGGER enable;

select count(*) from HR.TCDC_STATUS;

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

ORA-31693: Table data object "HR"."CD_COMP" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-24010: QUEUE SYS.HR_EVENT_Q does not exist

ORA-06512: at "SYS.DBMS_AQ", line 169

ORA-06512: at "HR.CD_COMP_INS_UPD_TRIGGER", line 9

ORA-04088: error during execution of trigger 'HR.CD_COMP_INS_UPD_TRIGGER'

alter trigger HR.CD_COMP_INS_UPD_TRIGGER disable;

select count(*) from HR.CD_COMP;

impdp "'/ as sysdba'" tables=HR.CD_COMP directory=PUMP dumpfile=dumpfile_exp_data.dmp  logfile=IBIPRD_CDW_imp_data_etl.log transform=storage:n TABLE_EXISTS_ACTION=APPEND

alter trigger HR.CD_COMP_INS_UPD_TRIGGER enable;

select count(*) from HR.CD_COMP;

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