>>Any bright ideas?
>
>I'd try COPY STRU EXTENDED, CREATE TABLE FROM, then APPEND FROM the busted table, and reindex. I would avoid just doing a straight COPY STRU, because I have seen corruption carry over to the new table using this method.

Also when you have a new structure you may try to do the data copy through the text file instead of straight APPEND FROM badtable.

copy to mydatafile delimited

use mynewdbf
append from mydatafile delimited