8/6/25, 4:29 PM Document 2867259.
1
PowerView is Off Last Login: July 2, 2025 10:22 PM COT Daila Diana (Available) (0) Contact Us Help
Dashboard Knowledge Service Requests Patches & Updates Community Powered by AI. Do not input sensitive data
Give Feedback...
Copyright (c) 2025, Oracle. All rights reserved. Oracle Confidential.
ORA-31626 ORA-31638 ORA-39077 ORA-972 ORA-24000 Errors from Data Pump Export (EXPDP) (Doc ID To Bottom
2867259.1)
In this Document Was this document helpful?
Symptoms Yes
No
Changes
Cause
Document Details
Solution
References
Type:
Status: PROBLEM
Last Major PUBLISHED
Update: 20-Jul-2024
Last 24-Sep-2024
APPLIES TO: Update: English
Language:
Oracle Database - Enterprise Edition - Version 19.15.0.0.0 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later Related Products
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Database - Enterprise
Gen 2 Exadata Cloud at Customer - Version N/A and later Edition
Information in this document applies to any platform. Oracle Database Cloud
Exadata Service
Oracle Cloud Infrastructure -
SYMPTOMS Exadata Cloud Service
Generation 1 - Exadata Cloud
at Customer (First Generation
Data Pump Export (expdp) using this syntax: Cloud Machine)
Gen 2 Exadata Cloud at
expdp system directory=<DirectoryName> dumpfile=<DumpFileName> logfile=<LogFileName> schemas=<SchemaName> Customer
Show More
fails with the following errors:
Information Centers
... Information Center:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Transportable Tablespaces
ORA-31626: job does not exist (TTS) for Oracle Database
ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_02 for user SYSTEM [1461278.2]
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.KUPV$FT", line 1744 19c Database Upgrade - Self
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 Guided Assistance with Best
ORA-06512: at "SYS.KUPV$FT_INT", line 498 Practices [1919.2]
ORA-39077: unable to subscribe agent KUPC$A_2_174121252895000 to queue "KUPC$C_2_20220428174119_0"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 Index of Oracle Database
ORA-06512: at "SYS.KUPC$QUE_INT", line 294 Information Centers
ORA-00972: identifier is too long [1568043.2]
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9306
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1873 インフォメーション・センタ
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3817
ORA-06512: at "SYS.DBMS_RULE_ADM", line 296 ー: データベースおよび
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 106 Enterprise Manager 日本語ド
ORA-24000: invalid value "SYS"."KUPC$C_2_20220428174119_0$10035", RULE SET should be of the form
[SCHEMA.]NAME キュメント [1946305.2]
ORA-00972: identifier is too long
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 109 Information Center: Data
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 97 Warehousing [1487754.2]
ORA-06512: at "SYS.DBMS_RULE_ADM", line 290
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3772 Show More
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3724
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1756
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1516 Document References
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9900
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9269 How To Reload Datapump
ORA-06512: at "SYS.DBMS_AQADM", line 881 Utility EXPDP/IMPDP
ORA-06512: at "SYS.KUPC$QUE_INT", line 267 [430221.1]
ORA-06512: at "SYS.KUPC$QUE_INT", line 1360
ORA-06512: at line 1
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 65
ORA-06512: at "SYS.KUPV$FT_INT", line 465 Recently Viewed
ORA-06512: at "SYS.KUPV$FT", line 1664
Bug 16928674 - Expdp / Impdp
Fail With ORA-25205 ORA-3907
ORA-39065 ORA-25205 [169286
DataPump Jobs Are Failing With
CHANGES 31626 ORA-31638 ORA-39077 W
Sequence
AQ$_KUPC$DATAPUMP_QUETA
> 6 Digits [2383405.1]
DataPump Export (EXPDP) Fails
Errors ORA-31693 ORA-922 Or
CAUSE 31626 ORA-31638 ORA-25448 O
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=292133983807025&id=2867259.1&displayIndex=4&_afrWindowMode=0&_adf.ct… 1/2
8/6/25, 4:29 PM Document 2867259.1
This issue is caused by a corruption in the Data Pump dictionary. 376 ORA-1110 When A Tablesp
Offline [1360966.1]
Expdp/Impdp Fails Due To Erro
ORA-39077,ORA-31638,ORA-
24000,ORA-00972 [2653853.1]
Database 12.1.0.2 Proactive Pat
SOLUTION Information [2285558.1]
Show More
Reload Data Pump.
Reference:
- How To Reload Datapump Utility EXPDP/IMPDP (Document 430221.1)
REFERENCES
NOTE:430221.1 - How To Reload Datapump Utility EXPDP/IMPDP
Didn't find what you are looking for? Ask in Community...
Related
Products
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > Data Pump Export > Administration
Oracle Cloud > Oracle Platform Cloud > Oracle Database Cloud Exadata Service > Oracle Database Cloud Exadata Service
Oracle Cloud > Oracle Platform Cloud > Oracle Cloud Infrastructure - Exadata Cloud Service > Oracle Cloud Infrastructure - Exadata Cloud Service
Oracle Cloud > Oracle Infrastructure Cloud > Oracle Cloud at Customer > Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine)
Oracle Cloud > Oracle Platform Cloud > Gen2 Oracle Database Exadata Cloud at Customer > Gen 2 Exadata Cloud at Customer
Keywords
DATAPUMP; EXPDP; EXPORT; PUMP; AUTOMATION
Errors
ORA-00972; ORA-24000; ORA-31626; ORA-31638; ORA-39077
Translations
English Source Japanese 日本語
Back to Top
Copyright (c) 2025, Oracle. All rights reserved. Legal Notices and Terms of Use Privacy Statement
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=292133983807025&id=2867259.1&displayIndex=4&_afrWindowMode=0&_adf.ct… 2/2
