Re: Database DBSpace

Posted in 1998

David Williams — Wed, 25 Feb 1998 07:24:21 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <6cutf3$8e3$1@news.xmission.com>, mbaumgartner@cardhealth.com writes > > >I have a database created in a non-root dbspace. I would like to relocate the >database, not any tables, to another dbspace without unloading/exporting the >database. Is it possible to relocate a database to another dbspace? > >Mark Baumgartner >Cardinal Health > > Are you using Online 7 or Online 5. If Onlne 7 then use lookup fragmentation, you can use something like ALTER INIT.. to refragement the table into one new dbspace. NOTE: This works under Workgroup Server which I didn't think supported fragmentation!! -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care