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 ...