My Oracle Support Banner

DataPump Export Of XMLSCHEMA Fails WIth Error ORA-22922 nonexistent LOB value (Doc ID 1499682.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Symptoms

During DataPump export of a schema that is registered to XML the following errors are raised:

...
Processing object type SCHEMA_EXPORT/XMLSCHEMA/XMLSCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [ ]
ORA-22922: nonexistent LOB value
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPW$WORKER", line 8164
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
0xb4e27540     19028  package body SYS.KUPW$WORKER
0xb4e27540      8191  package body SYS.KUPW$WORKER
0xb4e27540      2814  package body SYS.KUPW$WORKER
0xb4e27540      8846  package body SYS.KUPW$WORKER
0xb4e27540      1651  package body SYS.KUPW$WORKER
0x91dbb1d0         2  anonymous block
Job "SYSTEM"."SYS_EXPORT_SCHEMA_04" stopped due to fatal error at 11:45:23

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
References

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