Re: move database from 1 dbspace to another

Posted in 2000

Obnoxio The Clown — Fri, 24 Mar 2000 14:15:36 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Mr.B" <ben.depauw@freebel.net> > >I need to move a database from one dbspace to another. >As a systems operator I am not very familiar with the databse-tools: >what is the best thing to do? >I have IDS 7.3 running on a HP/UX 11.x. Unload the database, drop it and recreate it in the other instance (check out dbexport/dbimport) You can also use ALTER FRAGMENT statements to relocate the data, but that won't make the new dbspace the default dbspace for the database. Which might or might not be a problem for you. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com