Re: How to restore data from tape

Chengteh Lee wrote: > > Do you know what is the reason that table got dropped in > informix database? We use SCO/unix and informix se. > Not only the table(only one table) disappeared in the > database, but also we found some data lost in other > tables. > > We do have tape back up. Could you please tell me how to > load the data from tname.dat and tname.idx back to database? > Should I create a temp table using tname.dat and tname.idx > (how?) and then unload data and load them to the normal table? > > Chengteh > ------------------------------------------------------------ > AcuStaf Corporation Automated Staffing Systems > 5001 West 80th Street Payroll, Scheduling > Minneapolis, MN 55437 Time/Attendance ... > 612-831-4122 ext 248 http://www.acustaf.com > ------------------------------------------------------------ If you cant call a DBA, I suggest re-creating the table exactly as the old one was, with the same fields, indexes, and field paramaters, then put the old file over the new file (Which will probably have different names). Use the new file names. You may run into problems with this, but it might work. Hope you luck. Paul Fabozzi merlyn@fabozzi.com http://www.fabozzi.com