informix 表删除不掉的问题请帮忙解答！！

lxrcjxym

我使用的是informix 7.30 se版，有一个表在使用的时候出现 -105错误码，用bcheck 修复不了；删除这个表也删不了！请大侠们帮忙！！！谢谢

diablocom

-105    ISAM error: bad ISAM file format.

The contents of an ISAM file (table or index) have been corrupted. For
C-ISAM, if you used transaction logging, you can use the isrecover
program to recover the file. Otherwise, re-create the file or restore
it from backup. For SQL products, use the bcheck or secheck utility to
get more information on the problem and possibly correct it (use
the oncheck utility (or tbcheck with INFORMIX-OnLine versions 6.0 and
earlier). If the utility cannot recover the table or index, you will
have to re-create or restore it.


你看,解决办法很清楚.

studyingunix

将该表导出，然后重新初始化informix的共享内存，重启后将备份的表导入.试试吧!祝你成功.