Re: Error: Incorrect key file for table try to repair it
Thank you. As you suggest, a rude shut-down was probably the cause of crashed tables, though the web host denies this could have happened. Generally speaking, as web page records, only 1 record is queried at a time, by its specific ID number.
The `deleted` field facilitates flagging records as deleted (instead of allowing the client to delete records by mistake). A system administrator strongly advised me to use a `deleted` field in tables where clients and/or non-technical people have access to data. Having adopted the usage of a `deleted` column, occasional client-orchestrated deletions become recoverable.
Similarly, the `hidden` field is manipulated when publicly available records are incomplete (not ready for prime time).
Subject
Views
Written By
Posted
14678
December 06, 2011 01:06PM
4883
December 08, 2011 05:31AM
4654
December 09, 2011 12:40PM
Re: Error: Incorrect key file for table try to repair it
3588
December 09, 2011 07:48PM
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.