Re: Change Extends

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Sun, 17 Oct 1999 21:36:05 +0200
Message-ID: <380A2525.3876889C@wxs.nl>

The extent size as recorded for a tablespace are only the default values for all the objects created in that tablespace. Therefore the answer is yes, you can change both the INITIAL and the NEXT sized.

The same goes for all the other elements of the STORAGE clause. [If I remember correctly only PCTINC on a tablespace has one little sideeffect. If it is 0 then the tablespace is not automatically coalesced]

Erwin

Michael Mardorf wrote:
>
> Hi,
>
> is it possible to change the extend - size from tablespace after creating
> the tablespaces?
>
> Regards
> Michael Mardorf

--
Erwin Dondorp
<http://www.wxs.nl/~erwindon> Received on Sun Oct 17 1999 - 14:36:05 CDT