The Rebuild Key Files option on the Database Management menu applies only to files with FMS type 1 (APPXIO) and can be used to repair corrupted APPXIO index files. APPXIO files consist of two physical files, the “key” file which contains all indexes for a file and the location of their corresponding data in the “data” file. This option deletes the “key” file and reads the “data” file to generate a new “key” file for those files previously selected with the File Selection option.
On Windows systems, manually delete the “key” file and run the Create Files option. This will create a new “key” file using existing data.
On Oracle systems, execute a DROP INDEX command using SQL*PLUS and then run the Create Files option. APPX will create new indexes in Oracle and leave the existing table intact.