Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: corruption of index ?: ora-600

Re: corruption of index ?: ora-600

From: Hans.Wijte <Hans.Wijte_at_mail.ing.nl>
Date: 15 Feb 2006 00:57:15 -0800
Message-ID: <1139993835.446907.175640@g43g2000cwa.googlegroups.com>


00090 wrote:
> I have a table (around 8000K rows) with an index
> No error was reported with creating the index.
>
> when I try to select data from the table via the index, I get
>
> ORA-00600: code erreur interne, arguments : [12700], [28250], [33794730],
> [34], [50477210], [25], [], []
>
> this error is for the moment not document under metalink
>
> whe spend the lastest days making all kind of test but no one was
> successfully done
> (rebuild of index, rebuild of the index tablespace)
> db verify, moving the index tablespace to another filesystem
>
> oracle technical support explain that the index point to an non existant
> data block. with no more solution for the moment.
>
> for exemple the following select does not return the row
>
> create table test1 ( a number);
>
> insert into test1 values (1);
>
> select * from test1 where rowid = (select rowid from test1 where a = 1)
>
>
>
> Oracle is 9.2.0.7.0 (latest patch) under unix aix
>
> with all the tests, my dba has no more idea about what the problem is and
> how to solve it.
> if someone can help
> many tanks

When I look up "ora-0600 12700" in metalink I get a whole lotta answers, some
of them (but not all) to do with a mismatch between rowid (derived from an index)
and the datablock the rowid points to; eg. document 28229.1 Received on Wed Feb 15 2006 - 02:57:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US