none
Index does not match the table. Delete the index file and re-create the index (Error 114)

    Question

  • How do I recreate an index file for a table after the table has been recovered? 

    Thanks!
    Tuesday, July 26, 2005 1:55 PM

Answers

  • 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.
    Tuesday, July 26, 2005 2:35 PM

All replies

  • 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.
    Tuesday, July 26, 2005 2:35 PM
  • Thanks Craig!  I was able to do your second suggestion with success.  Big Smile

    Tuesday, July 26, 2005 5:25 PM