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....
>