RE: Freeing Extents
Alter fragment on table <tablename> init in <dbspace_name>;
This will rebuild the table, so you'll need to have enough space in your
target dbspace to hold a second copy (though, if it's empty, that's not
hard).
DC
> -----Original Message-----
> From: informix-list-bounces@iiug.org [mailto:informix-list-
> bounces@iiug.org] On Behalf Of Tam O'Shanter
> Sent: Friday, November 10, 2006 7:42 AM
> To: informix-list@iiug.org
> Subject: Freeing Extents
>
> 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.
>
> IFX 10.0UC5
>
> Thanks for the advice,
>
> Tam.
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list