Re: cannot specify pctincrease value when create tablespace

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Sat, 09 Feb 2002 17:27:40 +0400
Message-ID: <vs8a6ukbeur0b34rg3svehs7jmbtp9pq4d@4ax.com>

On Sat, 09 Feb 2002 12:43:01 GMT, "Richard Chen" <chenri_at_snet.net> 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)

The Spelling of Increase Matters ... ;-)

SQL> create tablespace MyTables datafile 'c:\temp\tmp.dbf' size 2M Default Storage(Initial 512K next 512K Maxextents Unlimited PCTINCREASE 0); Tablespace created.

SQL>
>
>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
>

HTH
[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Sat Feb 09 2002 - 07:27:40 CST