使用範圍：
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
HP-UX PA-RISC (64-bit)
HP-UX Itanium

詳情：
Index Organized Tables (IOT) can become corrupt if the associated tablespace was transported (TTS or Transportable Database) from a different Operating System Platform to HP (XTT / XTTS).

TTS= Transportable Tablespace.
XTT / XTTS =Transportable Tablespace from a different OS platform.

當我們使用傳輸表空間功能時，從其他平臺到HP的平臺造成讓索引組織表損壞

相關事件：
When using TTS or Transportable Database to HP:

HP-UX Itanium / HP-UX IA (64-bit)
HP-UX PA-RISC (64-bit) / HP-UX (64-bit)

from any of the next platforms: --也就是下面的平臺傳輸到HP平臺會造成上述問題

Linux x86 32-bit
Linux x86 64-bit
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit) / Solaris Operating System (x86-64)
IBM AIX on POWER Systems (64-bit) / AIX-Based Systems (64-bit)

症狀：

ORA-600 [6200] can be produced or ORA-600 [kddummy_blkchk] [file#] [block#] [6401] if db_block_checking is set to TRUE/FULL.

and the trace file may contain the corruption details like for example:

Block Checking: DBA = <rdba>, Block Type = KTB-managed data block
**** row 0: row length <length> past end of block
**** row 0: row skipped so other stats may be wrong
**** row 1: row length <length> past end of block
**** row 1: row skipped so other stats may be wrong
**** row 2: row length <length> past end of block
**** row 2: row skipped so other stats may be wrong
**** actual free space credit for itl <itl#> = <itl#> != # in trans. hdr = <hdr>
**** actual free space = <length> < kdxcoavs = 3405
**** actual unlocked split hole space = <value> != kdxlespl = <value>
**** key (begin=<offset>, len=<len>) overlaps with another
begin = 0xf81 len =<len>

DBVerify or RMAN with the check logical option may report the same corruption description.

目前辦法：
使用傳輸表空間後，重建索引組織表

補丁資訊：
There is not currently a patch for this issue.

This is a restriction caused by .

【BUG】當使用TTS（傳輸表空間時）從其他平臺到HP可造成索引組織表損壞

相關文章