Expdp/Impdp Fails Due To Errors -ORA-39077,ORA-31638,ORA-24000,ORA-00972 (Doc ID 2653853.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Symptoms

After db upgrade from 12.1 to 19.3,periodically datapump jobs fail with errors ORA-39077,ORA-31638,ORA-24000,ORA-00972.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31638: cannot attach to job SYS_IMPORT_FULL_01 for user xxxx
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 498
ORA-39077: unable to subscribe agent KUPC$A_1_104552960533000 to queue "KUPC$C_1_20200218104552_0"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 294
ORA-00972: identifier is too long
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9006
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1558
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3431
ORA-06512: at "SYS.DBMS_RULE_ADM", line 296
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 106
ORA-24000: invalid value "SYS"."KUPC$C_1_20200218104552_0$10016", RULE SET should be of the form [SCHEMA.]NAME
ORA-00972: identifier is too long
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 109
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 97
ORA-06512: at "SYS.DBMS_RULE_ADM", line 290
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3386
ORA-06512: at "SYS.DBMS_PR

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.