Moving database to separate dbspace

We have 2 databases, train and live, both in the same dbspace. We use ontape for backups and have found that we cannot restore to the train side only, because train is in dbs0, along with live. If train were in a separate dbspace, we could restore to it only and not overwrite live. Need help with moving train to a separate dbspace. I know how to create a new dbspace, but what are the next steps? Do we need to remove the old version of train first? Can we just do a onunload/unload to the new train dbspace? Thanks so much CKG

Honda75 wrote: > > We have 2 databases, train and live, both in the same dbspace. We use ontape > for backups and have found that we cannot restore to the train side only, > because train is in dbs0, along with live. If train were in a separate dbspace, > we could restore to it only and not overwrite live. Need help with moving train > to a separate dbspace. I know how to create a new dbspace, but what are the > next steps? Do we need to remove the old version of train first? Can we just do > a onunload/unload to the new train dbspace? > Thanks so much > CKG The easisiest way will be to do a dbexport with one database, drop it, and do an dbimport to the new sbspace. Wolfgang