cannot specify pctincrease value when create tablespace

From: Richard Chen <chenri_at_snet.net>
Date: Sat, 09 Feb 2002 12:43:01 GMT
Message-ID: <pP898.264$g34.104789120@newssvr10.news.prodigy.com>

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 Sat Feb 09 2002 - 06:43:01 CST