RMAN convert/xtts hpux itanium <-> linux x86-64

From: milist ujang <ujang.milist@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 24 Feb 2015 23:43:17 +0700

Hi All,

I had a case when after xtts conversion, the CLOB characters are getting
changes. from :

0111
<row id="0111" xml:space="preserve"><c1>1131139</c1><c2>6010</c2><c3>

to

0111
&lt;row id=&apos;0111&apos; xml:space=&apos;preserve&apos;&gt;&lt;c1&gt;11
31139&lt;/c1&gt;&lt;c2&gt;6010&lt;/c2&gt;&lt;c3&gt;

the table DDL area as follow:
CREATE TABLE X1
(
ID VARCHAR2(255),
XML1 SYS.XMLTYPE
)
TABLESPACE X1
PARTITION BY HASH (ID) PARTITIONS 256 STORE IN (X1)
XMLTYPE XML1 STORE AS CLOB X1LOB
( TABLESPACE X1
ENABLE STORAGE IN ROW
CACHE
)
;

it is not using xmlschema.

For the same scenario I used expdp/impdp and goldengate initial load, all
characters are exactly same.

My concern is downtime, using xtts it is amazingly very fast, expdp/impdp
or ogg initial load with parallel doesn't meet downtime duration.

according to support note:
CLOBs created in Oracle Database 10g and later releases are stored in
character set AL16UTF16, which is platform-independent.

I think something odd at SQL or other layers which I never know...
Could someone give me some light on this?

-- 
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

Follow-Ups:
- Re: RMAN convert/xtts hpux itanium <-> linux x86-64
  - From: David Barbour

RMAN convert/xtts hpux itanium <-> linux x86-64

Other related posts: