DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=KBVgZ/76ZcEhQRg+sUBJ3+Ore2/XRerc/kVNuPmQSeBjapM/gpzRSTZZkQt0jSMGJY5N7nSCSIwnjxx37sUG0WB1cWk0vv7i20D1N7bndcSeraVjPdxlbrx47JncqF1is35R9IH0s2sP8VMD5Xh018HMShDnJrkH3uS5nnVJQI4=
Message-ID: <40a16b360803181449g59dbbd0bk4b1c676ae4724df4@mail.gmail.com>
Date: Tue, 18 Mar 2008 14:49:19 -0700
From: "sol beach" <sol.beach@gmail.com>
To: oracle_l <oracle-l@freelists.org>
Subject: IMPDB & UTF8
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_13494_3532243.1205876959643"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: sol.beach@gmail.com
------=_Part_13494_3532243.1205876959643
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

While researching a problem we have I came across Note: *144808.1
it says in part....

*

For the moment, do NOT use Expdp/Impdp when going to UTF8 or a other multibyte
      characterset on ALL 10g versions including 10.2.0.3 and 11.1.0.6.
      It will provoke data corruption!
      This is caused by the impdp Bug 5874989.
<https://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=5874989.>
      The "old" exp/imp work fine. This problem is fixed in the upcoming
      10.2.0.4 and 11.1.0.7 patchsets.
      For 10.2.0.2 and 10.2.0.3 you can ask a backport for Bug 5874989
<https://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=5874989>
      if you need to use expdp/impdp.


So now I am back to using exp/imp again. :-(

------=_Part_13494_3532243.1205876959643
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

While researching a problem we have I came across Note: <font face="helvetica"><strong>144808.1&nbsp; <br>it says in part....<br><br></strong></font><pre><font><font face="courier">For the moment, do NOT use Expdp/Impdp when going to UTF8 or a other multibyte <br>
      characterset on ALL 10g versions including <a href="http://10.2.0.3">10.2.0.3</a> and <a href="http://11.1.0.6">11.1.0.6</a>. <br>      It will provoke data corruption!<br>      This is caused by the impdp <a href="https://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&amp;id=5874989.">Bug 5874989.</a><br>
      The &quot;old&quot; exp/imp work fine. This problem is fixed in the upcoming <br>      <a href="http://10.2.0.4">10.2.0.4</a> and <a href="http://11.1.0.7">11.1.0.7</a> patchsets.<br>      For <a href="http://10.2.0.2">10.2.0.2</a> and <a href="http://10.2.0.3">10.2.0.3</a> you can ask a backport for <a href="https://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&amp;id=5874989">Bug 5874989</a><br>
      if you need to use expdp/impdp.</font></font></pre><br><br>So now I am back to using exp/imp again. :-(<br><br>

------=_Part_13494_3532243.1205876959643--
--
http://www.freelists.org/webpage/oracle-l