Re: Oracle8: Is MAX EXTENTS still limit with 505?

> I try to overcome the limit of MAX EXTENTS which bother me since Oracle 7.
> I feel tired of recreate of tablespace with the new default storage value to
> fix
> the error MAX EXTENTS exceeded 505... I'm not sure MAX EXTENTS is
> unlimited with Oracle 8.
> Could someone help me with that? I'm working on Oracle 8.0.4/Dec Unix 4.0D.

Since at least 7.3 you have the possiblility to specify MAXEXTENTS UNLIMITED You can specify this for the tablespace in which case this value is the default
for all tables created in this tablespace. Once a table is created the settings of its tablespace no longer matter for that table.

You can specify a specific value for MAXEXTENTS for each table to overrule the default values
provided by the tablespace.

It is always advisable to specify a reasonable NEXT extent size such that the number of extents
will not be too excessive, even when MAXEXTENTS UNLIMITED is specified.

Another nice feature is to specify PCTINCREASE, with which the NEXT extentsize is increased
with the given percentage after each allocation of an extent. e.g. When NEXT=10K and PCTINCREASE=50,
the first allocated block is 10K, the next 15K, the next 23K, the next 35K etc.
[oracle performs some rounding up on these sizes so the given numbers are not exact]
But I guess that since the introduction of the unlimited extents this feature is used less and less.

It is never neccesary to recreate a tablespace when the max number of extents is reached.
It is sufficient to only rebuild the table for which this happened.

[btw. The value of MAXTEXTENTS (505 here) depends on your block size, a lot of others see this limit at 121 extents]

Erwin
--
Erwin Dondorp
<http://www.dondorp.com/> Received on Sat Oct 23 1999 - 07:33:04 CDT