RE: move database from 1 dbspace to another

Posted in 2000

Henderson, Scott — Fri, 24 Mar 2000 10:38:39 -0500 — source: Informix-list mailing list archive (1991-1998)

3 options come to mind. 1) dbexport/dbimport 2) onunload/onload 3) alter fragment on <table name> init in <dbspace>. Option # 3 will move only tables, database remains in dbspace. Not sure if this command works for system tables/views, doubtful. HTH Scott > -----Original Message----- > From: Mr.B [SMTP:ben.depauw@freebel.net] > Sent: Friday, March 24, 2000 7:30 AM > To: informix-list@iiug.org > Subject: move database from 1 dbspace to another > > Hi, > > 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. > > Thanks. > > Ben DE PAUW > (sysadmin)