Table index mismatch trace file

  • From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Jan 2008 12:35:23 +0000

Hi,
I have a table/index mismatch, the trace file from the validate command
shows me this:

Table/Index row count mismatch
table 20580403 : index 20685743, 105297
Index root = dba: 0x3400fa02

The first line on information does appear to be the row counts from the
table and an offending index.
Is there a way to use this to find out what the problem index is from the
"Index root" bit?

Thanks

Pete

Other related posts: