During Impdp: LPX-00235: Invalid XML Version, Must Be 1.0 Or 1.1 (Doc ID 2810371.1)

Last updated on JANUARY 28, 2022

Applies to:

Symptoms

On : 19.11.0.0.0 version, XML Database

ACTUAL BEHAVIOR
---------------
During impdp: LPX-00235: invalid XML version, must be 1.0 or 1.1

Customer is moving a schema from one database to another. The database versions are both 19.11
The charset for the source db is:
NLS_CHARACTERSET WE8ISO8859P1
The charset for the target db is:
NLS_CHARACTERSET AL32UTF8

The expdp worked without a single error
However, the impdp recorded several errors. One of them is this:
ORA-31693: Table data object "XXXXX"."XXXXXXX" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00235: invalid XML version, must be 1.0 or 1.1

The table was created but no rows were imported on the target. The source table has many rows and this is what showed during the export:
. . exported "xxx"."xxxxxxx" 799.9 MB 89224 rows

SQL>desc "xxx"."xxxxxx"
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 DOCUMENT_SEQ NOT NULL NUMBER(9)
 DATE_LOADED DATE
 STATUS VARCHAR2(1)
 DOCUMENT XMLTYPE
 EMAIL_FROM VARCHAR2(100)

Cause

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