I am trying to perform a dbexport to tape, but we have more than 2 GB of data. Is this possible to do? I am moving the database from 9.21.UC3 to 9.30.UC2. (raw disk with LVM and striping)..
I am 'moving' the current database to a new server, but do not want to keep the same dbspaces and table locking methods. Therefore I cannot use the onload/onunload utilities since I need to edit the schema.
I cannot perform the dbexport to disk since we do not have the room and the dbexport aborts.
Are my only 2 options below?
1. doing the individual unloads and unloading the large tables in increments
2. using onload, create the exact same database structure on the new server; then perform a dbexport from this databse which will allow me to modify the schema, create the 'final' databse and finally load all data from the 'replica' to the modified database via dbimport?