RE: break one dbspace in to two dbspace
Thanks for ur suggestion !!
First
thru dbschema I have cut all my create indexes part in one file
then move file to second file
then replace create to drop
then drop that indexes
then created new dbspaces add 2gb chunk
then used the first file created indexes
Regards
hiten
-----Original Message-----
From: Neil Truby [mailto:neil.truby@ardenta.com]
Sent: Thursday, October 02, 2003 1:16 AM
To: informix-list@iiug.org
Subject: Re: break one dbspace in to two dbspace
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message
news:blf3q8$b5buf$2@ID-64669.news.uni-berlin.de...
> Paul Watson wrote:
>
> > Create another dbspaces and then use alter table .. init .. command
> > to move the tables. Assuming you have detached indexes then they
> > will still be in the original dbspace.
>
> Are you on drugs, Paul? (Again? :o)
>
> Why not create the new dbspace, drop the index and recreate it in the new
> space?
More typing.
sending to informix-list