Re: need help with informix-se .dat,.idx

Posted in 1994

Jonathan Leffler — 2 Oct 1994 20:43:08 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: suroot@aol.com (Suroot) >Subject: need help with informix-se .dat,.idx >Date: 1 Oct 1994 17:11:08 -0400 >X-Informix-List-Id: <news.9013> > >I need a way to restore a .dat and .idx from backup into >a newly named table in my current database. > >Any help from those who know INFORMIX-SE better than I is >greatly appreciated. The best way to do this is probably: (1) Create a new table with the same structure (including the same indexes) as the table to be restored. (2) Note the names of the .dat and .idx files used to store the new table. (3) Recover the .dat and .idx files from tape and copy them over the files created for the new table. (4) Run update statistics. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>

Related threads

Different instances with markedly different times