Re: [Q] create tablespace with different block size error???

Comment in-line

On 01/23/2004 11:29:25 AM, dba1 mcc wrote:
> I tried to create tablespace with 16K (default on my
> init.ora blocksize =8k). I have error happen. The
> database version is 9.2.0.4.
>
> SQL> create tablespace "index1" logging datafile
> '/u0/oradata/leg92/index1.dbf' size 20m
> 2 blocksize 16384
> 3 autoextend on
> 4 next 1280k
> 5 maxsize unlimited
> 6 extent management local
> 7 segment space management auto
> 8 uniform size 128k;
> autoextend on
> *
> ERROR at line 3:
>
>
> if I take out "blocksize 16384", then it work fine.
>
> SQL> create tablespace "index1" logging datafile
> '/u0/oradata/leg92/index1.dbf' size 20m
> 2 reuse autoextend on
> 3 next 1280k
> 4 maxsize unlimited
> 5 extent management local
> 6 segment space management auto
> 7 uniform size 128k;
>
> Tablespace created.
>
> Does anyone know why??
>

Because "autoextend" is a datafile attribute, not a tablespace one. When you enter a tablespace attribute, like blocksize, oracle parser thinks that you're done describing your datafiles so it finds the "autoextend" clause out of context.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).