Table index mismatch trace file

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Wed, 30 Jan 2008 12:35:23 +0000
Message-ID: <5e317f310801300435k50ec3f1el855f6debca5d2728@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 30 2008 - 06:35:23 CST

Original text of this message