create of bigfile tablespaces

Creation Of bigfile tablespaces.

Code:

SQL>CREATE BIGFILE TABLESPACE big

    DATAFILE '/u01/oracle/oradata/orcl/big.dbf' SIZE 10G

    autoextend on

    EXTENT MANAGEMENT LOCAL

    SEGMENT SPACE MANAGEMENT AUTO;

The default tablespace type is SMALLFILE unless BIGFILE tablespace
clause is mentioned in the CREATE TABLESPACE command.

You can check the type of this tablespace in dba_tablespaces view.

Code:

SQL> select tablespace_name, bigfile from dba_tablespaces

     where tablespace_name='BIG';

TABLESPACE_NAME   BIGFILE

----------------   --------

BIG                 YES

Tablespace Block Size Maximum Tablespace Size


2K 8TB

4K 16TB

8K 32TB

16K 64TB

32K 128TB