Re: Table Restore

Fred Krefting wrote: > > I am using ontape to backup my databases. I have for the larger > databases one database per dbspace. Is there a way using ontape to > retrieve a single table, without doing a backup current, restore good, > unload table, and restore current? Currently this takes me approx. > 15 hours, and it is only going to get worse. This is the only way I've > been able to get back a table. I have some programmers who have on > occassion forgot what they were doing or which instance they were > pointing to. (:-( > > Any thoughts?? Fire them? Pro-rata a pay reduction based on the number of lost rows? 8-) There is no way to restore selectively with ontape. If you have certain tables you regularly restore, you might look at onunload and onload which do allow unloading and loading of tables at the page level. But you will still need your main level 0 archive! Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Email: marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+