Re: cannot specify pctincrease value when create tablespace

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 11 Feb 2002 17:26:29 GMT
Message-ID: <3C67FEC4.55BFA454@ci.seattle.wa.us>

The other answers are correct. But why of why are you creating a dictionary managed tablepace in 8.1.7? You should be using locally managed with uniform size where PCTINCREASE is irrelevant.

For example:

CREATE TABLESPACE xyz
DATAFILE 'u06/data/orabase/rbs01.dbf'
SIZE 500M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Daniel Morgan

Richard Chen wrote:

> This is done on oracle 8.1.7.0.1 on a redhat 7.2 linux box.
> The following fails:
>
> create tablespace ts1 datafile '/u/u01/app/oracle/oradata/pionex/ts101.dbf'
> size 100M autoextend on default storage (initial 10m next 10m maxextents
> unlimited PCTINREASE 0)
>
> ERROR at line 1:
> ORA-02143: invalid STORAGE option
>
> If I remove 'PCTINREASE 0' then it works. Since I don't want the default 50
> value
> for pctincrease, I have to do a an alter tablespace after that.
>
> My question is why I cannot specify 'PCTINREASE 0' when creating
> tablespace?
> Is this a bug in this version? Does it happen in other versions?
>
> Thanks for any info.
>
> Richard
Received on Mon Feb 11 2002 - 11:26:29 CST