Re: ora_600

Souri Bozorgmehri wrote:
> I have a big table in RAC 10g. After having hardware problem and
> fixing it, when I want to populate this table, I get ora_600 error. I
> have opened a ticket with Oracle Technet and they asked me to create
> another table and see if I can populate that table. I did, but I did
> not get any error message from the new table. It does not looks like
> that I have block corruption either. I am stuck and don't know what
> the problem can be. Any suggestion???

See what RMAN has to say about it:
http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1012.htm

See what dbms_repair has to say about it: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm

Did you search on the metalink ora-600 tool? What was the error? https://metalink.oracle.com/metalink/plsql/f?p=130:3:3621213965698277634::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame,p3_font:NOT,153788.1,1,1,1,helvetica

Are you saying you can select some column from the table, but if you try to insert a new row you get ora-600?

Have you tried CTAS from old table and inserting into new table?

Maybe you still have hardware problems...

jg

--
@home.com is bogus.
http://www.wimble.org/SoPrePlaTec/preventionhome.html