Re: re-creating .idx file
Note: usually you can unload the data since no indexes are required to dump
data. Then drop the table and reload, creating indexes after the loading is
completed. If you hosed your idx file shuffling files "usually" doesn't
help because the system (Informix) still thinks there is and index there.
JLG
26#e#Susik_Lee_at_United#u#Group#c##c#25#e#PC_CCMailSusik Lee
<@MAIL.FABRIK.COM> wrote in article <5a8qj9$roq@cssun.mathcs.emory.edu>...
> I'm not sure this will work or not:
> - copy idx file from one of other table where there is no index.
> - go into dbaccess or isql, than try to create index
>
> Susik
>
>
> ______________________________ Reply Separator
> _________________________________
> }Subject: re-creating .idx file
> }Author: The Mail Room, Inc.::(THMLRI) at ~FABRIK
> }Date: 12/27/96 8:06 AM
> }
> }
> }From: Kevin P.
> }Date: Fri, Dec 27, 1996 8:06 AM
> }Subject: re-creating .idx file
> }To: informix-list; Susik Lee
> }oops! i hammered an .idx file while trying to "fix" an indexing
<Stuff Removed>