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>
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-lReceived on Wed Jan 30 2008 - 06:35:23 CST