Re: inetrnal error code

barry.roomberg_at_compudata.com (Barry Roomberg) writes:
|> -> 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.

Also check the status of your rollback segments. If any of them appear in NEED RECOVERY state, you might want to contact your friendly Oracle Support folks if you have not done so already. Actually, you should check with them whenever you run into an internal error that disables your ability to get to important data.

Roderick Manalac
Oracle Corporation
corruption. Received on Thu Aug 25 1994 - 02:10:14 CEST