Re: ora 600 on linux after failed user level import

Oh yeah, forgot too mention. As she Metalink note says that the ORA-600 [12700] problem is a corrupt index (index pointing to a non-exsiting row), re-creating the index may fix the problem in the short term. However, the index problem likely occured due to a problem with the actual table itself. Which is what the ORA-600 [25012] indicates.

Seeing that this is in the SYSTEM tablespace and dictionary tables, I will try the following:
- full physical off-line backup (just in case)

• full db export
• re-create the physical (empty) db
• full db import

There are likely short cuts that can be tried (like fixing the SYSTEM tablespace first). But if all else fails, this is I think is a viable alternative that should work.

--
Billy