My Oracle Support Banner

Select gets wrong results due to Index (PK) Corruption (Doc ID 409176.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2.0.4 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.

Symptoms

After recovery, select from table returns incorrect results

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


SQL> analyze table user_profile_old validate structure cascade;
analyze table user_profile_old validate structure cascade
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file


/u02/tsorcl/dump/udump/Instance1_ora_8666.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /u01/opt/oracle/product/920
System name: Linux
Node name: <Node name>
Release: 2.4.9-e.59enterprise
Version: #1 SMP Mon Jan 17 07:02:16 EST 2005
Machine: i686
Instance name: Instance1
Redo thread mounted by this instance: 1
Oracle process number: 37
Unix process pid: 8666, image: oracle@Instance1 (TNS V1-V3)

Table/Index row count mismatch <<<<<<<<<<<<<<<<<<<<<< HERE IS THE POINT
table 251909 : index 251912, 2
Index root = tsn: 15 rdba: 0x038d6971

Changes

 

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
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.