Re: cannot specify pctincrease value when create tablespace

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 9 Feb 2002 22:54:36 -0000
Message-ID: <3c65b282_2@mk-nntp-1.news.uk.worldonline.com>

Did you try PCTINCREASE instead of PCTINREASE?

Paul

"Richard Chen" <chenri_at_snet.net> wrote in message news:pP898.264$g34.104789120_at_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 - 16:54:36 CST