Minimum Size for Bigfile Tablespace in 12c
(Doc ID 2076125.1)
Last updated on AUGUST 13, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata 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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |