Re: altering extent sizes

Neil Truby wrote: > > Greg wrote: > > > > See the SQL syntax guide. Focus on ALTER TABLE to change the NEXTSIZE > > (you can only set the initial size at create time...) ... > > > > Don't unload/reload. That's for Oracle Drudges. You have a better > > tool. Use it. Do something worthwhile with the time you save. > > > However, if his table is already in 142 extents, is altering the size of > the 143rd going to help much? > > Neil Sure, why not? Alter the next extent to 20-25% of current tablesize, then alter fragment init to rebuild and defrag the table to no worse than 4-5 extents. Problem Solved, no worries mate. Resist the urge to try to tweak the initial extent. The oft suggested unload; drop; create; reload method is a large PITA, especially if lots of referential constraints are involved. My preferred technique is much simpler and all but idiotproof (this is key for me....;-) Greg