Re: How to reuse pages in other tables?

In article <34E1C87A.58@bloomberg.com>, Art S. Kagel <kagel@bloomberg.com> writes >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? > I though it would since it since it effectively rebuilds the table behind the scenes using another partnum, hence you need 2x the space of the table. After all it must allocate pages (I've done this and the table moved chunks). the code for extent allocation is already there and so just creating a new partnum would probably be the way Onine does it (why would the Online developers write new code when you can reuse the existing code). >Art S. Kagel -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care