Re: altering extent sizes

For best results, change the nextsize first, then "ALTER FRAGMENT" to rebuild using the new NEXTSIZE. It really beats the daylights out of any other technique I've heard of. Greg Kenneth Ma wrote: > > Hi Neil: > > Do you mean to use command "Alter fragment ....init ...." to defrag the > table, then use command "Alter table modify next size" to increase the > next extent size to avoid large number of future extent (due to growth)? snip....