Re: altering extent sizes

At one of my sites the DBA didn't have time to get involved in analysing / monitoring 900+ tables so they used tbunload, tbload (version 5) occasionally to clean up. Also, I was pleasantly surprised when moving from V5 to V7 the dbimport automatically set next extent size to 10% (I think) of the table size. -- Paul White paulwh@masterpiece.alphalink.com.au Greg Moye <greg.moye@eds.com> wrote in article <35E5709A.5C23@eds.com>... > Just to repost for public consumption, to reorg and defrag table1 after > setting NEXTSIZE to say 20-50% of current table size (depending on size > and how fast you expect it to grow), use: > > ALTER FRAGMENT ON TABLE table1 INIT IN targetdbs;> > Source and target dbspace can be the same. > > It doesn't get any easier or more bulletproof. > > Greg > > > Kate_Tomchik@homedepot.com wrote: > > > > What does it mean to alter fragment init? > > > snip.... >