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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 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

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