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

From: David Barbour <david.barbour1_at_gmail.com>
Date: Tue, 24 Feb 2015 16:03:53 -0600
Message-ID: <CAFH+ifesB6mAfenOqm7POhRv3tvGCn_yf6ATFXrUB8Pu2oaqGA_at_mail.gmail.com>

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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 24 2015 - 23:03:53 CET