Re: altering extent sizes

See the SQL syntax guide. Focus on ALTER TABLE to change the NEXTSIZE (you can only set the initial size at create time...) and the "ALTER FRAGMENT ...INIT " SQL. Life will be good. Don't unload/reload. That's for Oracle Drudges. You have a better tool. Use it. Do something worthwhile with the time you save. Greg 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) > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum