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