My Oracle Support Banner

how an xml unsupported character can be removed from a table and reinserted. (Doc ID 2272700.1)

Last updated on DECEMBER 10, 2019

Applies to:

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


Import fails with below error

ORA-31693: Table data object "TEST"."FBNK_CND_000" 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-00217: invalid character 0 (U+0000)

And the corrupted sql can be identified by

LPX-00217: invalid character During IMPDP: How To Find The Corrupted XML Data On SOURCE Table (Doc ID 1531866.1)

 At the same time,select on the table holding the problematic row at the source end also fails

SQL> select * from FBNK_CND_000 where rowid='AAD+p1ACSAACzv2AAC';
OCI-31011: XML parsing failed


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

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