Re: question about initial extent

Hi Andi,

500 K.

The storage clause of the segments in a tablespace will override the tablespace default storage settings. EXCEPT for MINIMUM EXTENT.

This applies to dictionary managed tablespaces (DMT). Using locally managed tablespaces (LMT) eliminates the above + many other problems, e.g. it buries the treacherous PCTINCREASE once and for all.

• Kenneth Koenraadt

andihp_at_flashmail.com (andi) wrote in message news:<16ce60f4.0301041846.2f268343_at_posting.google.com>...
> Hi All.
> If a tablespace is created using clause MINIMUM EXTENT 500K
> then a table is created on that tablespace with storage clause INITIAL 200K,
> which size will be taken to create the initial extent for the table?
> 200K or 500K?
>
> TIA,
> andi
Received on Sun Jan 05 2003 - 02:57:25 CST