Monday, 1 December 2014

ORA-00382: 32768 not a valid block size, valid range [2048..16384]

SQL> create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 32k;
create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 32k
*
ERROR at line 1:
ORA-00382: 32768 not a valid block size, valid range [2048..16384]

Reason:- Won't support 32k block size, for OS 32 bit.

SQL> create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 16k;
create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes

Reason:- Need to adjust your cache size

SQL> alter system set db_16k_cache_size=50M scope=memory;

System altered.

Then try 
SQL> create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 16k;

Tablespace created.
SQL> select tablespace_name,block_size from dba_tablespaces;

TABLESPACE_NAME                BLOCK_SIZE
------------------------------ ----------
SYSTEM                               8192
SYSAUX                               8192
UNDOTBS1                             8192
TEMP                                 8192
USERS                                8192
BIGTBS                              16384

6 rows selected.



Popular Posts