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]
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.
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.
No comments:
Post a Comment