DataPump Import (IMPDP) Reports The Error LPX-210 When XMLTYPE Is Involved (Doc ID 1368572.1)

Last updated on NOVEMBER 06, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Jun-2013***

Symptoms

When using DataPump to import a table with a column of type XMLTYPE from database 11.2 with character set WE8ISO8859P1 into a database 11.2 with character set AL32UTF8 and the parameter REMAP_SCHEMA is used, then the following errors occur:

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "TC""PLANRESULT_0" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '?'
Error at line 1


The error LPX-210 error text sometimes differs in respect of the 'instead of' character, e.g.:

LPX-00210: expected '<' instead of '„¢'
LPX-00210: expected '<' instead of 'A'


If the target database has the character set WE8ISO8859P1, then there is no error reported.

The table description shows, there is at least one XMLTYPE column involved:

SQL> desc PLANRESULT_0
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
UNID                                      NOT NULL NUMBER
ID                                        NOT NULL VARCHAR2(256)
SLICE                                     NOT NULL NUMBER
DAY                                       NOT NULL NUMBER
TYPE                                               VARCHAR2(40)
XMLSTRING_B                                        CLOB
OWNER                                              VARCHAR2(20)
RESOURCE                                           VARCHAR2(1)
TIMESTAMP                                 NOT NULL NUMBER
XMLSTRING                                          SYS.XMLTYPE
DIRTY                                              NUMBER


If the parameter REMAP_SCHEMA is omitted from the import syntax, then the import fails with OERI klxpr_73 at the same statement the original LPX-210 error was received on:

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "QNAMICRMD"."PLANRESULT_0" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-600: internal error code, arguments: [klxpr_73], [17], [0], [1], [25496],[34], [], [], [], [], [], []

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