Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: corruption of index ?: ora-600
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