Re: Backup & Restore Granularity

Paul Reimold wrote: > > I am fairly new to Informix admin. I was surprised (and disappointed) to > learn that On-Tape, On-Archive (and, I believe the up-coming On-Bar) > back up and restore only at the dbspace level. WHY NOT AT THE TABLE > LEVEL? > > If a user is in dbaccess, it is frightlenly easy to drop a table. > Indeed, the term 'drop' implies to me that one simply does not want to > work with a table any more, not the more serious action of blowing it > away! > > Other than assigning a dbspace to each table, is there any other way to > backup/restore individual tables? Take a look at onunload. It will unload at the database or table level, and works at the page level, so is fast. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto: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! | +------------------------+-----------------------------------------+