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
- Follow-Ups:
- Re: Table index mismatch trace file
- From: Stefan Knecht
Other related posts:
- » Table index mismatch trace file
- » Re: Table index mismatch trace file
- » Re: Table index mismatch trace file
- Re: Table index mismatch trace file
- From: Stefan Knecht