Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Hakan factor

Re: Hakan factor

From: M. Zinn <riviera71.bt_at_gmx.de>
Date: Tue, 08 Feb 2005 19:54:35 +0100
Message-ID: <e02i01d361f4dfl8bd17901ekeaq1hvkpt@4ax.com>


"David Aldridge" <slimdave_at_yahoo.com> wrote:

>Metalink Note 293396.1 describes the procedure ...
>
>1) recreate the segment to have the hakan factor computed correctly
>
>- OR -
>
>2) change the segment to nocompress and then back again to compress -
>this will also force the hakan factor to be re-computed

Thanks for the hint.
So, what is meant by segment? I guess it means "object" and therefore the index on the big table.

As a workaround we do the partition exchange without indexes and rebuild the index partitions later.

Michael Received on Tue Feb 08 2005 - 12:54:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US