Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] create tablespace with different block size error???

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

From: Krishna Kakatur <Krishna.Kakatur_at_Sun.COM>
Date: Fri, 23 Jan 2004 10:24:34 -0800
Message-ID: <F001.005DDFDA.20040123102434@fatcity.com>

You may want to define DB_16K_CACHE_SIZE in init.ora, or use ALTER SYSTEM to set this value.

HTH,
Krishna



NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishna Kakatur
  INET: Krishna.Kakatur_at_Sun.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).
Received on Fri Jan 23 2004 - 12:24:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US