Can't do 'UPDATE STATISTICS' bec. of corrupted 'table'

Hi, Hardware: AT&T 6386 computer running AT&T Unix SysV3.2 rel. 2.3 isql -v: 2.10.00B i4gl -v: 1.10.00B/2.10.00B c4gl -v: 2.10.00B sqlexec -V: 4.00.UH1 Problem: Cannot 'update statistics' on the database bec. of corrupted system/database table(s). Error: Cannot create sysindexes Method to 'update statistics': isql (Q)uery Language (D)atabase type 'update statistics' press ESCape (R)un Error message at bottom of screen: 'Cannot create sysindexes for d10____176'. Steps made: a 1. I went to the [database].dbs directory. 2. Did an ls on the directory 3. Didn't find the d10____176.idx and d10____176.dat files 4. Found the d10___212.idx and d10____212.dat files Possible solution: 1. Unload d10 to flat file; Drop d10; reload d10; recreate indexes on d10. 2. Unload all database files; Drop database; Recreate database; Recreate tables; Load data (I don't like this as there are *LOT* of tables and we don't have the disk space) 3. Delete some rows in sysindexes (Kludge but I really don't want to do this bec. I'm not sure how it is formatted or if I still have to remove some records in other sys-tables) So my question is, can you suggest a way that can restore the integrity of the database without taking up much time? THANKS! John -- John Fontanilla | Work: (203) 790-9921 AOH: (203) 350-3841 Transportation Data |E-mail: john@gagme.wwa.com,john@gaboon.newnet.com 100 Mill Plain Rd. | Views expressed does not reflect that of my employers. Danbury, CT 08611 | Maligayang bati sa inyo!!! :)