Re: re-creating .idx file
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
}problem with one of the tables in my system. yes, i know that
}it says practically everywhere in the manuals not to do this,
}but i figured if it was hosed already, what could it hurt. so,
}while i sit here listening to my multiple tape backup set whir,
}i figured i'd also ask the experts.
}
}the details:
}
}informix se v4.00
}sco unix v3.2v4 (for what its worth)
}
}i accidentally deleted the tablename.idx file, although the
}tablename.dat file is still there. is there a way to re-create
}the .idx?? i have tried CHECK TABLE, REPAIR TABLE,
}but no luck.
}
}please e-mail response to me.
}
}kpavlish@themailroom.com
}
}thanks
}-k
}
}----------
}Received: from rmy.rmy.emory.edu by portia.fabrik.com
} with SMTP (Fabrik F07.0-000)
} id SINN.5334282@portia.fabrik.com ; Fri, 27 Dec 1996 09:30:47 -0800
}Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id MAA28645
}
}for susik.lee@uica.com; Fri, 27 Dec 1996 12:31:15 -0500 (EST)
}From: "Kevin P." <kpavlish@themailroom.com>
}Message-Id: <01bbf40f$fc49c380$04d0e926@tosheeba.themailroom.com>
}Subject: re-creating .idx file
}Date: 27 Dec 1996 16:06:58 GMT
}Reply-To: "Kevin P." <kpavlish@themailroom.com>
}Organization: The Mail Room, Inc.
}Sender: informix-list-owner@rmy.emory.edu
}To: informix-list@rmy.emory.edu
}X-Informix-List-To: susik.lee@uica.com
}X-Informix-List-Id: <news.32017>
}
}----------
}