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

来源：互联网发布：稳定的排序算法编辑：程序博客网时间：2024/06/06 03:57

转自:

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

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

SOLUTION

The minimum and maximum size for bigfile tablespace creation depending on BLOCK size:

BLOCK SIZE   MINIMUM SIZE    MAXIMUM SIZE
        2K            133K                     8 TB
        4K                137K                    16 TB
        8K              6265K                    32 TB
       16K           8113K                  64 TB
       32K           11937K                   128 TB

REFERENCES

BUG:21864664 - REGRESSION CREATE TABLESPACE

阅读全文

0 0