Re: Freeing Extents
Is oncheck -m supported on 10? (Check CDI Archive for details)
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Obnoxio The Clown" <obnoxio@serendipita.com>
>To: "Tam O'Shanter" <tam@oshanter.com>
>CC: informix-list@iiug.org
>Subject: Re: Freeing Extents
>Date: Fri, 10 Nov 2006 14:53:17 -0000 (GMT)
>
>
>Tam O'Shanter said:
> > Hello,
> >
> > Is there any way to free extents allready claimed by a table after
> > removing
> > data from said table?
> >
> > Running out of disk space for a table and I wish to delete an ammount of
> > data.
>
>I don't know if there's anything new in 10 to take of this, but I'd do an
>ALTER INDEX TO CLUSTER after the delete.>
>--
>Bye now,
>Obnoxio
>
>"... no bill is required as no value was provided."
>-- Christine Normile
>
>--
>This message has been scanned for viruses and
>dangerous content by OpenProtect(http://www.openprotect.com), and is
>believed to be clean.
>
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
The new Windows Live Toolbar helps you guard against viruses
http://toolbar.live.com/?mkt=en-gb