Re[2]: re-creating .idx file
This can be done in a few steps:
1 - create a new table w/the exact same structure as the old one
(column names, indexes etc) but w/a different name
2 - modify the row in systables for the old table to point to the new
one. (i think the column is path -- you'll see it when you select
w/the tabname = the old one)
3 - copy your old .dat file over the top of the new table, renaming it
to the same name as the new .dat file
4 - do a "repair table" on the new table - this will re-create all of
the indexes.
5 - rename the new table to have the name of the old one.
Hope this helps
jim
______________________________ Reply Separator _________________________________
Subject: Re: re-creating .idx file
Author: "James L. Gehring" <jgehring@apk.net> at Internet
Date: 12/30/96 10:11 PM
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>