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

I'm on 11.2.0.4 + cpu jan 2015; source & target.

Had submitted sr since 10 days ago but no conclusion so far.

On 2/25/15, David Barbour <david.barbour1_at_gmail.com> wrote:
> What version of Oracle are you using? You should take a look at DOC ID
> 1454872.1
>
> On Tue, Feb 24, 2015 at 10:43 AM, milist ujang <ujang.milist_at_gmail.com>
> wrote:
>
>> 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
>>
>

-- 
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab
--
http://www.freelists.org/webpage/oracle-l