Re: How do I restore a single table?

I am not very sure, but I feel you can do warm restore of that dbspace which contains the table on some other server and then unload it. Before this you might want to take 0 level backup of that other server. Vinod Bhansali >From: sleesingchan@my-deja.com >Reply-To: sleesingchan@my-deja.com >To: informix-list@iiug.org >Subject: How do I restore a single table? >Date: Tue, 23 May 2000 13:02:15 GMT > >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. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com