RE: How do I restore a single table?

BMC has a product called SQL-Backtrack that does this. Check www.bmc.com -----Original Message----- From: sleesingchan@my-deja.com [mailto:sleesingchan@my-deja.com] Sent: Tuesday, May 23, 2000 9:02 AM To: informix-list@iiug.org Subject: How do I restore a single table? Hello, Does anyone know of an easy way to restore a single table from an Informix ontape backup? I'm using IDS 7.31 on Digital Unix 4.0 I know that I can restore the whole instance using ontape -r, but I that would mean that I would lose the work done in other tables. I have to resort to restoring the whole instance on another server since I don't want to interrupt work being done by users on the production system. Then I unload the data from the table from the restored instance and load this back into the production system. Please, tell me that there is an easier way to do this!!?? I can't believe that Informix has overlooked this very important task. How have others been coping with this shortcoming (by Informix)? Are there any 3rd party utilities that can provide this functionality? Thanks very much for your input. Regards, Samuel Lee. Systems Analyst. Trinidad & Tobago Electricity Commission. sleesing@ttec.co.tt Sent via Deja.com http://www.deja.com/ Before you buy.