Re: Table index mismatch trace file

You can use the following in sql*plus to get to the object in question:

SET ECHO ON

UNDEF rdba

SELECT dbms_utility.data_block_address_file(
         to_number(trim(leading '0' from
replace('&&rdba','0x','')),'XXXXXXXX')
       ) AS rfile#,
       dbms_utility.data_block_address_block(
         to_number(trim(leading '0' from
replace('&&rdba','0x','')),'XXXXXXXX')
       ) AS block#
FROM dual;


and then use the resulting file number and block number in dba_extents to
find the index.

Stefan



On Jan 30, 2008 1:35 PM, Peter Hitchman <pjhoraclel@xxxxxxxxx> wrote:

> 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
>



-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

Other related posts: