Re: altering extent sizes
Posted in 1998
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
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