Incorrect key file for table
Hello,
when I try to make a query on my database that uses multiple tables it sometimes returns that kind of error: "Incorrect key file for table '/tempfs/#sql_2747_0.MYI'; try to repair it". But when I limit data with WHERE it is sometimes returning good result. I tried backuping and restoring db in other schema and repairing the only one myisam table that is in this query.
Subject
Views
Written By
Posted
Incorrect key file for table
2840
September 14, 2011 06:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.