Re: Table index mismatch trace file
Date: Wed, 30 Jan 2008 16:03:05 +0000
Message-ID: <5e317f310801300803i672e54abtd865b7df79dc9a5e@mail.gmail.com>
Hi,
Thanks Stefan, just what I needed.
Pete
On Jan 30, 2008 2:08 PM, Stefan Knecht <knecht.stefan_at_gmail.com> 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_at_gmail.com> 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_at_trivadis.com
> http://www.trivadis.com
>
> OCP 9i/10g SCSA SCNA
> =========================
-- Regards Pete -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 30 2008 - 10:03:05 CST