Re: extent

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Tue, 15 Aug 2000 09:31:49 +0200
Message-ID: <3998F1E5.1842BF96@cern.ch>

Hello,

Or it could be done by deallocation of the unused space. From Oracle manual (Release 8.0)...

"ALTER TABLE table DEALLOCATE UNUSED KEEP integer;

When you explicitly identify an amount of unused space to KEEP, this space is retained while the remaining unused space is deallocated. If the remaining number of extents becomes smaller than MINEXTENTS, the MINEXTENTS value changes to reflect the new number. If the initial extent becomes smaller, the INITIAL value changes to reflect the new size of the initial extent."

Hth,

Erika

SP wrote:
>
> Oracle experts:
> Is it possible to modify the size of initital extent of a table with a alter
> table (or any) command?
> TIA
> SP
Received on Tue Aug 15 2000 - 02:31:49 CDT