False Corruption ORA-1498 for Compressed tables
(Doc ID 2789589.1)
Last updated on JULY 06, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52.0 [Release 12.2 to 19]
Information in this document applies to any platform.
Analyze table validate structure of compressed tables fails with ORA-1498, but DBV or RMAN check logical validate doesn't detect any corruption.
ORA-1498 tracefile shows block is corrupted, but doesn't say how Oracle judged it is corrupted.
Blockdump is written in readable format, not binary dump, and contains for each block
skipping corrupted block at rdba: xxxxxxxxxx
9ir2 HEAP BLOCK FORMAT
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document