After Upgrade to 12.2,analyze table on certain %$MIG tables fails with "ORA-01498: block check failure"
(Doc ID 2451375.1)
Last updated on FEBRUARY 23, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
After upgrade from 12.1 to 12.2 (different OS versions),it is noticed that ANALYZE TABLE SYS.”CON$MIG” return “ORA-01498: block check failure – see trace file”.
SQL> ANALYZE TABLE SYS.”CON$MIG” VALIDATE STRUCTURE CASCADE ONLINE;
ANALYZE TABLE SYS.”CON$MIG” VALIDATE STRUCTURE CASCADE ONLINE
*
ERROR at line 1:
ORA-01498: block check failure – see trace file
SQL> ANALYZE TABLE SYS.”CON$MIG” VALIDATE STRUCTURE ONLINE;
ANALYZE TABLE SYS.”CON$MIG” VALIDATE STRUCTURE ONLINE
*
ERROR at line 1:
ORA-01498: block check failure – see trace file
Integrity of Datafile is fine-
# DBVERIFY output of SYSTEM tablespace :
[…]
BR0395I Verifying <name>.data using DBVERIFY…
BR0396I Verification of <name>.data using DBVERIFY successful
[…]
Cause
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
Symptoms |
Cause |
Solution |
References |