Re: How to reuse pages in other tables?

If you are talking about alter index to cluster then yes it does free = space, down to the limit of the initial extent size. I have replication log tables that are very volatile and can be blown out = to several hundred meg in a days activity during the peak of the season. = I resize these nightly using 'alter index to cluster' and the space is = recovered. Just to complete Davids list, my fave for recovering space, and simultaneou= slly moving the table to a different dbspace is to use the fragment = syntax. fragment table tablename init in dbsname; rgds Peter Tashkoff <tashkop@iname.com> Zespri International Limited. Standard Disclaimers apply All rights reserved, no party may use this document to vilify another Zespri New Zealand Kiwifruit, The Worlds Finest >>> "Art S. Kagel" <kagel@bloomberg.com> 12/02/98 04:49:14 >>> David Williams wrote: >=20 > In article <34E08969.7442@bloomberg.com>, Art S. Kagel > <kagel@bloomberg.com> writes > >Leonids.Voroncovs@dati.lv wrote: > >> 3rd question: Can I use pages allocated for this table ( but not used = ) > >> for other tables? > >Only by dropping the table and recreating it. You can perform such > >compression on a table with data by either > >1) unload the data (using dbaccess/4Gl unload command, dbexport, or > >onunload), drop the table, recreate the table, reload the data or > >2) create a new table insert into new_table select * from old_table, > >then drop old_table, rename new_table to old_table. > Or do alter index to cluster for an index on the table. That will defragment the table but I did not think that it will release=20 any space? Does this really release unused space Dave? Art S. Kagel