Re: Table index mismatch trace file
- From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 16:03:05 +0000
Hi,
Thanks Stefan, just what I needed.
Pete
On Jan 30, 2008 2:08 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:
> 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
> =========================
--
Regards
Pete
Other related posts:
