Re: ora_600

Thx, I fundout that we have about 10 corrupted blocks in the table. I have to use expdp and impdp to export and import the database. Doing so, I have to put flag that oracle by passes the corrupted blocks. Any suggestion on how to do this. Is there any scripts that I can use?

Thanks,

Souri

joel garry wrote:
> 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
Received on Fri Aug 25 2006 - 23:42:46 CDT