oracle导入错误31623,数据泵ORA-31623数据泵错误处理

EXPDP/IMPDP 导入导出报错

接到客户反馈，数据泵impdp导入报错，以下是关于ora-31623数据泵错误处理https://www.cndba.cn/Marvinn/article/2670

https://www.cndba.cn/Marvinn/article/2670https://www.cndba.cn/Marvinn/article/2670

UDI-31623: operation generated ORACLE error 31623

ORA-31623: a job is not attached to this session via the specified handle

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

ORA-06512: at line 1

Question: I am running a Data Pump import (impdp) and I get the following ORA-31623 error:

ORA-31623: a job is not attached to this session via the specified handle

How do I fix the ORA-31623 error: a job is not attached to this session via the specified handle?

Answer: Data Pump import and export job use queues, streams and java objects.

If we see any job component is invalid (e.g. dbms_java, queue dict