Minimum Size for Bigfile Tablespace in 12c (Doc ID 2076125.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

CREATE BIGFILE TABLESPACE "BIG_TBL" DATAFILE '${ORACLE_DB_DATA}/big_tbl1.dbf' SIZE 262144
AUTOEXTEND ON NEXT 262144 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;


CREATE BIGFILE TABLESPACE "BIG_TBL" DATAFILE
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required

Changes

Upgraded to 12c. 

On 11g the minimum is 256K for block size 8K.

 

Cause

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 hundreds of Community platforms