FW: Testing the ontape utility?

-----Original Message----- From: John Carlson Sent: Monday, August 07, 2000 3:38 PM To: 'Mahmoud Kamoun' Subject: RE: Testing the ontape utility? Let's see . . . . . > -----Original Message----- > From: Mahmoud Kamoun [mailto:kamounm@usgs.gov] > Sent: Sunday, August 06, 2000 12:08 PM > To: informix-list@iiug.org > Subject: Testing the ontape utility? > > > I'm trying to find out if the Ontape is working properly, in > development, > using the following scenario: > > - create a dbspace, OK > - create a database, OK > - add 4 tables with data > - perform an archive with the ontape utility, > - delete drop 2 tables from the database, OK again > - restore the dropped tables and How would you restore the dropped tables individually? Ontape only restores an entire Informix instance, not individual tables. When you run the ontape restore, the tables will be recreated intact with data at the time of the archive. > - check if the dropped tables are restored. . . . . after the restore (ontape -r). Hope this clarifies things. John Carlson Informix DBA EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330