inetrnal error code

-> ora-00600: internal error code, arguments: (4147), (16), (10), (),
-> (), ()
-> The query does a select on a number of columns of one table with a
-> where clause
-> to limit the search on one particular data item and there is an order
-> by. BUT,
-> the error comes up without the order by also. In fact, with the where
-> and without the order by (in the same select) it fails.
->
-> What is the most likely problem here? Is there a fix?

Most likely a corrupted data block. Hope for index. Drop the index and recreate it if there are any. Data should be OK if you can do an EXP.

If you can EXP, then recreate the database and do an IMP. Scan those disks for errors. Received on Wed Aug 24 1994 - 16:43:00 CEST