My Oracle Support Banner

Creating a Tablespace with a Non-Standard Blocksize and DB_nK_BUFFER_CACHE not configured results in ORA-29339 (Doc ID 138227.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

You create a tablespace with a non-standard blocksize of 2K:

   SQL> create tablespace tbs2K
     2  datafile '/export/home1/ora900/oradata/<SID>/tbs2K.dbf'
     3  size 2M
     4  blocksize 2k;

   Tablespace created.

You want to create a tablespace with another non-standard blocksize of 8K, and
get the following error:
 
   SQL> create tablespace tbs8K datafile
     2  '/export/home1/ora900/oradata/<SID>/tbs8K.dbf' size 2M
     3  blocksize 8k;
   create tablespace tbs8K datafile
   *
   ERROR at line 1:
   ORA-29339: tablespace block size 8192 does not match configured block sizes

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.