SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL>
SQL> create tablespace zyp datafile '/home/oracle/zyp.dbf' size 10M blocksize 16k;
create tablespace zyp datafile '/home/oracle/zyp.dbf' size 10M blocksize 16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
SQL> !
[oracle@ora11 ~]$ oerr ora 29339
29339, 00000, "tablespace block size %s does not match configured block sizes"
// *Cause: The block size of the tablespace to be plugged in or
// created does not match the block sizes configured in the
// database.
// *Action:Configure the appropriate cache for the block size of this
// tablespace using one of the various (db_2k_cache_size,
// db_4k_cache_size, db_8k_cache_size, db_16k_cache_size,
// db_32K_cache_size) parameters.
[oracle@ora11 ~]$ exit
exit
SQL> show parameter cache_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_size big integer 0
db_flash_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
SQL>
SQL>
SQL> alter system set db_16k_cache_size=10M scope=both;
SQL> create tablespace zyp datafile '/home/oracle/zyp.dbf' size 20M blocksize 16k;
Tablespace created.
SQL> create tablespace zyp_1 datafile '/home/oracle/zyp_1.dbf' size 30M blocksize 16k;
Tablespace created.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28278387/viewspace-749254/ ,如需转载,请注明出处,否则将追究法律责任。