onload/onunload all tables EXCEPT ones specified

Hi all, We have a database that contains 700 tables which we backup and restore monthly using onunload and onload commands. That database contains one table which is rather large (a LOB table) which is NOT required for monthly reporting in the restored area. I know that you can use onunload and specify tables to be backed up, but is there a way to specify tables that are NOT to be backed up? For example, this will only backup the mydb:images table: onunload -t /dev/rmt0 -b 16 -s 4000000 -d myspace mydb:images But if I wanted all tables except mydb:images is there a "not" feature? Example: onunload -t /dev/rmt0 -b 16 -s 4000000 -d myspace !mydb:images Maybe wishful thinking so I don't have to list 699 tables so I don't back up the one I don't want... Thx Steve

You could move the images table to it's own dbspace but I haven't used onload/onunload for a while. "Steve N." wrote: > > Hi all, > > We have a database that contains 700 tables which we backup and > restore monthly using onunload and onload commands. That database > contains one table which is rather large (a LOB table) which is NOT > required for monthly reporting in the restored area. > > I know that you can use onunload and specify tables to be backed up, > but is there a way to specify tables that are NOT to be backed up? For > example, this will only backup the mydb:images table: > > onunload -t /dev/rmt0 -b 16 -s 4000000 -d myspace mydb:images> > But if I wanted all tables except mydb:images is there a "not" > feature? Example: > > onunload -t /dev/rmt0 -b 16 -s 4000000 -d myspace !mydb:images> > Maybe wishful thinking so I don't have to list 699 tables so I don't > back up the one I don't want... > > Thx > > Steve -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #