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

  • From: David Barbour <david.barbour1@xxxxxxxxx>
  • To: ujang.milist@xxxxxxxxx
  • Date: Tue, 24 Feb 2015 16:03:53 -0600

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@xxxxxxxxx>
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
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2015