Google+ Facebook Twitter MySpace SC

Friday, September 7, 2012

Note 1039393 - DATAPUMP creates corruptions in tables with LONG (RAW)

 

Summary
Symptom***********************************************************************
This note is issued as a Hot News. Check the note regularly for updates. Otherwise, you will not be aware of important changes regarding prerequisites, consequences and solutions. A new Hot News is not issued if a note is updated.
***********************************************************************
After you reorganize a table with a LONG or LONG RAW column using the Oracle Data Pump

  • the dbv reports: "kdbchk: the amount of space used is not equal to block size"
  • ora-01498 is reported when the table is accessed
  • block corruptions in the relevant table are reported by R3Check (provided that this table is a cluster table)
Other termsCluster table
LONG RAW
Corruption
Reorganization
R3Check
DBverify
Analyze

Reason and Prerequisites
This problem is caused by Oracle Bug 5941030.
Only tables with LONG RAW or LONG columns are affected.
You installed database version 10.2.0.2.

Solution
The bug is corrected as of Oracle Release 10.2.0.4.

For Oracle Release 10.2.0.2, install the bug fix that is relevant for your platform. The bug fixes are available on SAP Service Marketplace in the software center under:
http://service.sap.com/swcenter-3pmain
in the following directories:

AIX 5L with Oracle 64 bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
AIX_5L_64/p5941030_10202_AIX64-5L.zip

Linux 32-bit
/Oracle/Oracle 32-bit/Oracle 10.2.0. 32-bit/Oracle 10.2.0.2/
Linux_32/p5941030_10202_LINUX.zip

Linux x86-64
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Linux_x86_64/p5941030_10202_Linux-x86-64.zip

LINUX Itanium 64
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
LINUX_IA_64/p5941030_10202_LINUX-IA64.zip

LINUX IBMPower 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Linux_ppc_64/p5941030_10202_IBMPower.zip

HP-UX PA-RISC 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP-UX_64/p5941030_10202_HP64.zip

HP UX Itanium 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP_IA_64/p5941030_10202_HPUX-IA64.zip

HP TRU64
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP_TRU64/p5941030_10202_TRU64.zip

SUN Solaris 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Solaris_SPARC_64/p5941030_10202_SOLARIS64.zip

SUN Solaris x86-64
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Solaris_x86_64/p5941030_10202_Solaris86-64.zip

Windows 32-bit / 64-bit (Windows IA64 / x86-64)
Patch 4883635 is available for Oracle 10.2.0.2 as of patch 16.
For availability, see Note 871735.


Workaround:
Do not perform table reorganizations for tables with LONG or LONG RAW columns using the Oracle Data Pump.
Do not use the option from BR*Tools.
Use the previous method using exp/imp instead.


This note will be updated as soon as more patches are made available.

Header Data


Release Status:Released for Customer
Released on:21.01.2008 15:45:43
Master Language:German
Priority:HotNews
Category:External error
Primary Component:BC-DB-ORA Oracle

RELATED POSTS

Useful links for SAP BW


No comments:

Post a Comment