Re: altering extent sizes
Kate_Tomchik@homedepot.com wrote:
>
> What does it mean to alter fragment init?
The command:
ALTER FRAGMENT ON <tablename> INIT IN <dbspace>;
will move an existing tables extents to another (hopefully smaller) set
of extents on the same or a different dbspace. It is the fastest way
to compress a table with many extents into the smallest number of
extents possible. See my response to Sahrul Hidayat today, Subject:
"Re: altering extent sizes", for details about optimizing the outcome.
Art S. Kagel