Re: Corrupt sysindexes.

Be warned - I'm under the influence of influenza and the associated medication! On 29 Dec 97 at 19:48, Mike South wrote: > I have a database that was rarely used but recently when I tried to > access it, it owuld immediatetly crash the server on connecteing. > > The problem turned out to be a corrupt index on the systables table, > tabname to be exact. Repairing the index would crash the server, OK > I dont need the databse anyway so I try to drop it...NOPE crashes > the server. OK I go into sysindexes and delete the index from the > table. Still can't drop the database, cant rename it > either...Anybody got any ideas on how to get rid of it. I don't know if it's practical, but how about dbexporting the databases you want to keep, re-initializing your instance and then re-importing? Tell me more about these Georgia Peaches and Southern Belles, please! :-) -- Ciao, Billy Back at the gold-face in sunny Gauteng... Informix FAQ @ http://www.iiug.org/techinfo/faq/faq_top.html Drivel @ http://www.west.co.za/tasteless/