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

最新推荐文章于 2021-12-23 21:48:42 发布

转载最新推荐文章于 2021-12-23 21:48:42 发布 · 701 阅读

文章标签：

#bigfile #max #tablespace

本文介绍Oracle 12c中创建大文件表空间所需的最小尺寸要求，包括不同块大小对应的最小及最大尺寸，并提供具体示例。

转自:

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