Med Java

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Create bigfile tablespace ======

BIGFILE tablespaces are useful for databases that require **very large files**, as they can theoretically accommodate up to **8 exabytes (EB)** in size.

Syntax is:
<code>
CREATE BIGFILE TABLESPACE tablespace_name 
    DATAFILE 'file_location_and_name' SIZE file_size 
    [AUTOEXTEND ON [NEXT size_increment] [MAXSIZE { UNLIMITED | max_size }]]
    LOGGING | NOLOGGING
    EXTENT MANAGEMENT LOCAL 
    [SEGMENT SPACE MANAGEMENT { AUTO | MANUAL }];
</code>

Example:
<code>
CREATE BIGFILE TABLESPACE big_ts 
    DATAFILE '/u01/app/oracle/oradata/mydb/big_ts01.dbf' SIZE 100G 
    AUTOEXTEND ON NEXT 10G MAXSIZE 500G 
    NOLOGGING 
    EXTENT MANAGEMENT LOCAL 
    SEGMENT SPACE MANAGEMENT AUTO;
</code>

<code>
CREATE BIGFILE TABLESPACE "LARGETBS"
NOLOGGING
DATAFILE 'D:\ORACLE\LARGETBS' SIZE 51200K AUTOEXTEND ON
</code>

<note important>
A bigfile tablespace contains **only one data file** or temp file. This is in contrast to SMALLFILE tablespaces, which can contain multiple files. 
</note>

===== Create bigfile tablespace for ASM =====

Replace +DATADISK with your ASM disk:

<code>
CREATE BIGFILE TABLESPACE DATA 
DATAFILE '+DATADISK' 
SIZE 100G 
AUTOEXTEND ON 
NEXT 10G 
MAXSIZE 500G
</code>