Unload, drop, recreate and reload. See the Informix Load FAQ.
www.artentech.com/downloads.htm

If you are using XPS you could just create a copy of the table, but with 7x
or 9x you'd want the performance of the HPL to move the data around.

cheers
j.
----- Original Message -----
From: "JAMES SWALLOW" <JSWALLOW@greenbay.k12.wi.us>
To: <informix-list@iiug.org>
Sent: Monday, January 26, 2004 11:30 AM
Subject: Releasing extents from a table.


> I am in need of some general information about releasing extents from a
table that I will be trimming and releasing those extents back to the
database. The information I have at hand is not clear about this process.
>
> Thanx, Jim Swallow GBAPS
>
>
>
> sending to informix-list


sending to informix-list