RE: Tablespace reorg tools

From: <George.Brennan_at_warnermusic.com>
Date: Thu, 27 Apr 2000 11:32:03 GMT
Message-Id: <10480.104274@fatcity.com>

> Deepak,
>
> I believe COMPRESS=Y will resize the initial extent, but the next
> extent will remain the same size. If initial was 16K and next was
> 16K, and you have inserted a few thousand records, and export
> with COMPRESS=Y, oracle will recalculate the initial (so all records
> fit in the initial extent) *but* the next extent will still be 16K.
> This is usually a *bad* thing.
>

Ok, I'll bite, why is it usually a *bad* thing?

George. Received on Thu Apr 27 2000 - 06:32:03 CDT