Re: How to reuse pages in other tables?

David Williams wrote: > > 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 any space? Does this really release unused space Dave? Art S. Kagel