IMPDB & UTF8
From: sol beach <sol.beach_at_gmail.com>
Date: Tue, 18 Mar 2008 14:49:19 -0700
Message-ID: <40a16b360803181449g59dbbd0bk4b1c676ae4724df4@mail.gmail.com>
Date: Tue, 18 Mar 2008 14:49:19 -0700
Message-ID: <40a16b360803181449g59dbbd0bk4b1c676ae4724df4@mail.gmail.com>
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. :-(
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 18 2008 - 16:49:19 CDT