Link to home
Start Free TrialLog in
Avatar of Mahmoud Al Jundi
Mahmoud Al JundiFlag for Jordan

asked on

ORA-00600: internal error code, arguments: [6731], [1], [0], [62], [], [], [], [ ]

Hello

I am getting the following error when trying to update a table in Oracle 8.1.6 ,
I tried to update other tables but the error is coming while updating this table !!!

Any Ideas Please
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Besides the fact that your Oracle version is ancient (you probably have some reason not to upgrade) can you clarify whether updates to other tables are working or not? And when did this issue start? Did anything change that needs to be mentioned?
Avatar of Mahmoud Al Jundi

ASKER

Update other tables are working fine,started yesterday when I killed a session while it is updating a huge table.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

The ORA-600 is one of those errors that pretty much needs Oracle Support to diagnose.  Since 8i has LONG been desupported, you may be out of luck.

Since you killed a session that was in the middle of an update statement you may have some data, block or table corruption.

I would first try to see if you can create a new table copy:
create table my_table_bkup as select * from my_table;

Verify the data is all there (a couple of minus queries).  Then try the update on the new table.

If all that works, then it is probably some corruption somewhere.

I would look at a permanent recreation of the table.
I have created a new copy of that table and it works fine, Do u think dropping the table and import a new backup file will solve the issue ?
If you created a copy like slightwv above is suggesting then all data is already in the copy of your table. Then there would be no need to import from backup. Why would you want to import from backup?
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>then I suspect indexes

Excellent suggestion!  I forgot about indexes.

Yes, try a rebuild before all the trouble of a copy/rename of tables.
What I did , I restarted the DB for and everything worked fine
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.