Datapump export to Object storage fails with UDE-31626 ORA-31626 ORA-39086
(Doc ID 2970517.1)
Last updated on OCTOBER 06, 2023
Applies to:
Autonomous Database Serverless - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Datapump export to Object storage failing with below errors :
Export: Release 21.0.0.0.0 - Production on Wed Aug 23 13:35:15 2023
Version 21.11.0.0.0
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "ADMIN"."EXP2": admin/********@testdb schemas=test_schema directory=data_pump_dir credential=test_cred dumpfile=https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/test_namespace/b/test_bucket/o/exp1%U.dmp exclude=statistics filesize=5GB logfile=export.log job_name=exp2
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/USER
UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4790
ORA-06512: at "SYS.KUPV$FT_INT", line 2299
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2279
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2272
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2277
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |