Moving database to new dbspace?
Posted in 2017
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
Informix 12.10
Solaris 10 1/13
I would like to move a database into a new dbspace. Not just tables, but the
whole database (meaning catalog, and anything else that may be associated with
it). That is, at the end of the operation, I would like the state of the
Informix instance to be the same as if I had originally created the database
in the new dbspace.
I'm thinking that dbexport/dbimport will do exactly that (if I specify the new
dbspace with the -d option).
Am I correct?
Thank you.
Regards,
DG
If and only if the whole database lives in a single dbspace and you do the
export without the -ss option, that will indde work. If things are more
complicated, then you can use myimport's dbspa e remapping feature to
restore objects to different dbspaces.
Art
On Jan 21, 2017 15:06, "DAVID GROVE" <david.grove@alaska.gov> wrote:
> Informix 12.10
> Solaris 10 1/13
>
> I would like to move a database into a new dbspace. Not just tables, but
> the
> whole database (meaning catalog, and anything else that may be associated
> with
> it). That is, at the end of the operation, I would like the state of the
> Informix instance to be the same as if I had originally created the
> database
> in the new dbspace.
>
> I'm thinking that dbexport/dbimport will do exactly that (if I specify the
> new
> dbspace with the -d option).
>
> Am I correct?
>
> Thank you.
>
> Regards,
>
> DG
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045d5b10db7fb30546a37c20