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.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 23, 2004 10:29 AM
To: Multiple recipients of list ORACLE
And ... what is the error number that you get ?
Note : If you are creating a tablespace with the non-standard blocksize,
you must have db_cache_Xk_size configured and running for your instance
before you create the tablespace.
Hemant
At 08:29 AM 23-01-04 -0800, you wrote:
I tried to create table
Because, you left db_16k_cache_size parameter to the default value of 0 (zero).
- Kirti
--- dba1 mcc <[EMAIL PROTECTED]> 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 tablespac
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
informa
On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote:
Because, you left db_16k_cache_size parameter to the default value of
0 (zero).
- Kirti
He probably has left db_16k_cache_size parameter but the problem
described here is with syntax, not the cache size. Parser stops
looking or file attributes
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 blocksi
It is NOT true. I did put db_16k_cache_size on
init.ora file. I still work with ORACLE support
engineer tried to find problem.
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande
> wrote:
> > Because, you left db_16k_cache_size parameter to
> the defa
What amateur of Oracle support engineer are you working with?
Mladen is right. Your syntax is wrong. Read the documentation (and suggest
to the engineer he do the same):
SQL> create tablespace "INDEX1" logging datafile
'/u01/ORACLE/ora92/INDEX11.dbf' size 5m
2blocksize 16384
3