创建非默认块大小的表空间

 

1.创建块大小为16k的表空间报错误

SQL> create tablespace tps_hxl_16
  2  datafile 'C:\APP\ADMINISTRATOR\ORADATA\HXL11G\hxl01.DBF' size 128m
  3  blocksize 16k;
create tablespace tps_hxl_16
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes

 

2.查看如下参数
SQL> show parameters db_16k_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------------
db_16k_cache_size                    big integer 0

 

3.将该参数的值设置大于0

SQL> alter system set db_16k_cache_size=1 scope=both;

System altered.

 

5.重新创建成功
SQL> create tablespace tps_hxl_16
  2  datafile 'C:\APP\ADMINISTRATOR\ORADATA\HXL11G\hxl01.DBF' size 128m
  3  blocksize 16k;

Tablespace created.

 

-- The End --