创建 块大小为16K的表空间 语法

SQL> show parameter cache_size
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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_keep_cache_size                   big integer 0
db_recycle_cache_size                big integer 0

SQL> alter system set db_16k_cache_size = 100M;
System altered

SQL> show parameter cache_size
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size                    big integer 100M
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_keep_cache_size                   big integer 0
db_recycle_cache_size                big integer 0
  
SQL> create tablespace TBS_LJB_16K
  2  blocksize 16k
  3  datafile 'D:\oracle\product\10.2.0\oradata\orcl\TBS_LJB_16K_01.DBF' size 100M
  4  autoextend on
  5  extent management local
  6  segment space management auto;
  
Tablespace created
 
SQL> drop table t_16K purge;
Table dropped
SQL> create table t_16K tablespace TBS_LJB_16K as select * from dba_objects ;
Table created

SQL> select count(*) from t_16K;
  COUNT(*)
----------
     50622

SQL>