Home » RDBMS Server » Server Utilities » expdb can corrupt data
expdb can corrupt data [message #382731] Fri, 23 January 2009 15:27 Go to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
from Doc ID: 119119.1

IMPORTANT: 

* Do NOT use Expdp/Impdp when going to (AL32)UTF8 or a other multibyte 
  characterset on ALL 10g versions lower then 10.2.0.4 (including 10.1.0.5).
  Also 11.1.0.6 is affected.

  It will provoke data corruption unless you applied Patch 5874989 on the 
  impdp side, this is caused by the impdp Bug 5874989. Expdp is not affected.

  The "old" exp/imp work fine. This problem is fixed in the 
  10.2.0.4 and 11.1.0.7 patch set.

  All existing patches for this bug are found here: 
  http://updates.oracle.com/download/5874989.html

  For 10.1.0.5 and 11.1.0.6 you can ask a backport for Bug 5874989 
  if there is not yet a patch for your version/platform.
Re: expdb can corrupt data [message #382757 is a reply to message #382731] Sat, 24 January 2009 06:30 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for the details.

Babu
Previous Topic: Not able to load the from the flat file.
Next Topic: SQLLDR Import Time string as seconds
Goto Forum:
  


Current Time: Sat Apr 27 17:04:46 CDT 2024