Re: Database reorg

Posted in 1998

Neil Truby — Fri, 28 Aug 1998 19:39:02 +0100 — source: Informix-list mailing list archive (1991-1998)

Bill Weaver wrote: > > I need to do some major reorg of my database including the moving of many tables from one > dbspace to another. Is there an "easy" and possibly quicker way of doing this short of unload, > drop, recreate, load method? To move a table from dbspace1 to dbspace2, and re-build it: ALTER FRAGMENT on table1 init in dbspace2 If you don't want to move the table, specify ... init in dbspace1. This will still re-build the table. Neil Truby Londis Holdings London, UK