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
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
Oracle Database
Last Comment
Steve Wales
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?
ASKER
Update other tables are working fine,started yesterday when I killed a session while it is updating a huge table.
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.
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.
ASKER
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
>>then I suspect indexes
Excellent suggestion! I forgot about indexes.
Yes, try a rebuild before all the trouble of a copy/rename of tables.
Excellent suggestion! I forgot about indexes.
Yes, try a rebuild before all the trouble of a copy/rename of tables.
ASKER
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.