SQL> alter system set db_8k_cache_size=32m scope=both;

系统已更改。

SQL> create tablespace tbs_8k datafile 'E:\ORACLE\ORADATA\TSTDB\tst_8k_01.DBF' s
ize 20m  blocksize 8192;

表空间已创建。

SQL> select a.tablespace_name,a.block_size,a.logging from dba_tablespaces a;

TABLESPACE_NAME                                              BLOCK_SIZE LOGGING
------------------------------------------------------------ ---------- --------
----------
SYSTEM                                                             4096 LOGGING
UNDOTBS1                                                           4096 LOGGING
TEMP                                                               4096 NOLOGGIN
G
DRSYS                                                              4096 LOGGING
EXAMPLE                                                            4096 LOGGING
INDX                                                               4096 LOGGING
ODM                                                                4096 LOGGING
TOOLS                                                              4096 LOGGING
USERS                                                              4096 LOGGING
XDB                                                                4096 LOGGING
USED_TEST                                                          4096 LOGGING
PERFSTAT                                                           4096 LOGGING
TEST                                                               4096 LOGGING
TABLESPACE_TST                                                     4096 LOGGING
TBS                                                                4096 LOGGING
TBS_8K                                                             8192 LOGGING

已选择16行。