Re: pct_increase won't change in dba_segment?

Jackie,

The tablespace level pct_increase is applied to objects created in the tablespace that do not specify the pct_increase (this is true for other such parameters e.g. pct_free, max_extents, etc.). If you tables were created before the change they'll have to be altered individually.

As to your second question there is no "extents" column in the dba_extents view. There is an extent_id and I believe the initial extent is number 0. Note that segments are made up of extents.

Ken F.

Jackie A. Marino <Jackie.A.Marino_at_tgpl.twc.com> wrote in article <34D89E45.45B_at_tgpl.twc.com>...
> I have changed the pct_increase parameter to 0 of a tablespace. In the
> dba_tablespaces table, pct_increase reads 0, but in dba_segment table,
> it still reads it's defualt value of 50. What's the true pct_increase
> value?
>
> Also, why do all extents = 0 in dba_extents? In dba_segments the extent
> value varies. I guess I'm confused on how to read the system tables.
>
> Thanks for your help,
>
> Jackie Marino
>
Received on Wed Feb 04 1998 - 00:00:00 CET