ORA-29339_ora-29339: tablespace block size 32768 does not ma-优快云博客

本文链接：https://blog.youkuaiyun.com/chengxuefei_bj/article/details/9121805

本文详细阐述了如何使用SQL*Plus创建具有32KB块大小的表空间，并解决了与数据库配置块大小不匹配的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[aix1]:[/dsg]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 18 16:30:06 2013

SQL> conn / as sysdba
Connected.
SQL> CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
2 '+DATA2/db11/datafile/block01.dbf' SIZE 1G AUTOEXTEND ON NEXT 128K MAXSIZE 1G
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
7 BLOCKSIZE 32K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON;
CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
*
ERROR at line 1:
ORA-29339: tablespace block size 32768 does not match configured block sizes

SQL> show parameter db_32k_cache_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_32k_cache_size big integer 0
SQL> alter system set db_32k_cache_size=64M;

System altered.

SQL> show parameter db_32k_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_32k_cache_size                    big integer 64M
SQL> CREATE TABLESPACE BLOCK_32K_SPACE DATAFILE
2    '+DATA2/db11/datafile/block01.dbf' SIZE 1G AUTOEXTEND ON NEXT 128K MAXSIZE 1G
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
7 BLOCKSIZE 32K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON;
/

Tablespace created.

SQL>