RE: Restore a table

Ok. Let's say, I need to restore some tables from historical tapes in order to feed my DWH. These tables are in specific dbspaces, so I think I wouldnt have to restore the full instance. But, as I dont store logical log backup tapes older than 8 days; do I have to restore the full instance? > -----Mensaje original----- > De: Murray Wood [SMTP:murray@quanta.co.nz] > Enviado el: Mi'rcoles 6 de Diciembre de 2000 09:28 PM > Para: informix-list@iiug.org > Asunto: RE: Restore a table > > If you dont backup logs you can never restore anything other than the full > instance. Any other situation would make the dbspace inconsistent with > the > informix in rootdbs and the SMI tables. > > MW > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Carlos > Kobashikawa C. > Sent: Thursday, December 07, 2000 1:57 PM > To: informix-list@iiug.org > Subject: RE: Restore a table > > > > eonder@my-deja.com wrote: > > > >>> I need to restore only a table from an archive; how can I do > this ? > > >It is possible only if this table is created in it's own dbspace. > >So, You can restore this particular dbspace. > > But, if I didnt have logical logs backup tapes (I only store level 0 > tapes), I couldnt restore only a particular dbspace. > Another way?