SQL> create tablespace ts16k
2 datafile 'C:\app\Administrator\oradata\orcl\ts16k.dbf'
3 size 50m blocksize 16k;
create tablespace ts16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
SQL> show parameter block
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_file_multiblock_read_count integer 128
SQL> show parameter db_16k_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
SQL> alter system set db_16k_cache_size=100m;
System altered.
SQL> create tablespace ts16k
2 datafile 'C:\app\Administrator\oradata\orcl\ts16k.dbf'
3 size 10m blocksize 16k;
Tablespace created.
SQL>
2 datafile 'C:\app\Administrator\oradata\orcl\ts16k.dbf'
3 size 50m blocksize 16k;
create tablespace ts16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
SQL> show parameter block
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_file_multiblock_read_count integer 128
SQL> show parameter db_16k_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
SQL> alter system set db_16k_cache_size=100m;
System altered.
SQL> create tablespace ts16k
2 datafile 'C:\app\Administrator\oradata\orcl\ts16k.dbf'
3 size 10m blocksize 16k;
Tablespace created.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-2149417/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26870952/viewspace-2149417/