Re: Importing a compressed table doesn't go to smallest suitable free space

chicnorm_at_norm.inforamp.net (Norm LeBlanc) wrote:
>I am trying to import a table that I had previously exported with the
>compress extents option and I am expecting it to be placed in the
>smallest available contiguous block of free space that it will fit in.
>But this does not happen. Am I expecting too much?
>
>Dinesh Fernandopulle
>
>
My understanding of "compress extents" is that the initial extent storage parameter is set equal to the sum of existing extents allocated. It does not adjust for actual data volumes.

Ken F.

-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~