[aix1]:[/dsg]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 18 16:30:06 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
2 '+DATA2/db11/datafile/block01.dbf' SIZE 1G AUTOEXTEND ON NEXT 128K MAXSIZE 1G
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
7 BLOCKSIZE 32K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON;
CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
*
ERROR at line 1:
ORA-29339: tablespace block size 32768 does not match configured block sizes
SQL> show parameter db_32k_cache_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_32k_cache_size big integer 0
SQL> alter system set db_32k_cache_size=64M;
System altered.
SQL> show parameter db_32k_cache_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_32k_cache_size big integer 64M
SQL> CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
2 '+DATA2/db11/datafile/block01.dbf' SIZE 1G AUTOEXTEND ON NEXT 128K MAXSIZE 1G
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
7 BLOCKSIZE 32K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON;
/
Tablespace created.
SQL>