[oracle-l] Re: [Q] create tablespace with different block size error???
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'ORACLE-L@xxxxxxxxxxx'" <ORACLE-L@xxxxxxxxxxx>
- Date: Fri, 23 Jan 2004 11:09:32 -0600
dba1
I think you must first create a buffer cache for this block size.
http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: dba1 mcc [mailto:mccdba1@xxxxxxxxx]
Sent: Friday, January 23, 2004 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: [Q] create tablespace with different block size error???
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??
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dba1 mcc
INET: mccdba1@xxxxxxxxx
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@xxxxxxxxxxx (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).
Other related posts:
