My Oracle Support Banner

TTS changed XMLTYPE from CLOB to Binary, XML Tag Syntax are Changed (Doc ID 1989198.1)

Last updated on JANUARY 25, 2023

Applies to:

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

Symptoms

CT is performing crossplatform tablespace from HP-UX IA 11.31 oracle version is 11.2.0.4 to linux x86-64 oracle version 11.2.0.4 using RMAN XTTS.

They followed step-by-step from note 371556.1 and http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-platformmigrationtts-129269.pdf

After the conversion, the data changes especially for XML tag syntax.

Regardless conversion by rman on source or target , XMLTYPE on top of CLOB change symbol ">" to &gt

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
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.