Re: altering extent sizes

mdevlin8648@my-dejanews.com wrote: > > i have posted previously regarding the large number of extents present in our > database. I intend to unload tables from dbspaces and reload them, > rebuilding the dbspace. how can i also alter the extent sizes. I realize > that it isn't critical because the data will be re-loaded contiguosly to the > disk I want to adjust it so that when running my scripts that check for > number of extents that these tables wont how up again with the large number. > Is there a better remedy to my dilemma? Thanks for all the help (past and > present) Before compressing the table ALTER TABLE ... NEXT SIZE n; then compress the data. BTW in case noone has mentioned it rather than unload and reload consider using ALTER FRAGMENT ... INIT IN ...; This works fine for unfragmented as well as fragmented tables and can compress the table into the same or a different dbspace and does NOT require room for the entire copied table to work. It is the FASTEST way to defragment a table. Art S. Kagel