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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 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
[XMLSCHEMA:"PCMADMIN"."http://www.kluwer.nl/source/schemas/kluwer/xsd/metadata.xsd"]
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms