Tags: database, delete, error, file, foxpro, index, match, microsoft, mysql, oracle, re-create, recovered, recreate, sql, table
Index does not match the table. Delete the index file and re-create the index (Error 114)
|How do I recreate an index file for a table after the table has been recovered? |
Leave a comment...
- 2 Comments
- There are a couple of options..
REINDEX is the easiest, but if the key information stored in the CDX is corrupt, it will create corrupt indeces.
The best way is to DELETE TAG <tag>, then do an INDEX ON <key> TAG <tag>. However, if you are using persistent relations, they will be removed with the DELETE TAG command.#1; Sun, 09 Sep 2007 20:53:00 GMT
Thanks Craig! I was able to do your second suggestion with success.#2; Sun, 09 Sep 2007 20:54:00 GMT