CREATE TABLESPACE MWF_TABLESPACE
DATAFILE 'MWF_TABLESPACE.dat' SIZE 50M
DEFAULT STORAGE
(
    INITIAL 10M NEXT 50M
    MINEXTENTS 1 MAXEXTENTS 999
    PCTINCREASE 10
)
ONLINE;

BIGFILE | SMALLFILE

Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace. This clause overrides any default tablespace type setting for the database.

A bigfile tablespace contains only one data file or temp file, which can contain up to approximately 4 billion (232) blocks. The maximum size of the single data file or temp file is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks.

A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 data files or temp files, each of which can contain up to approximately 4 million (222) blocks.

If you omit this clause, then Oracle Database uses the current default tablespace type of permanent or temporary tablespace set for the database. If you specify BIGFILE for a permanent tablespace, then the database by default creates a locally managed tablespace with automatic segment-space management.

Restriction on Bigfile Tablespaces 
You can specify only one data file in the DATAFILE clause or one temp file in the TEMPFILE clause.

CREATE TABLESPACE EXP_TABLESPACE
DATAFILE 'EXP_TABLESPACE.dat' SIZE 1GB
AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ONLINE;

CREATE TABLESPACE EXP_TABLESPACE
DATAFILE 'EXP_TABLESPACE01.dbf' SIZE 1GB
AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ONLINE;

CREATE TABLESPACE EXP_TABLESPACE
DATAFILE '<drive_letter>\oracle\oradata\XE\EXP_TABLESPACE01.dbf' SIZE 1GB
AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ONLINE;

orclz>
orclz> create tablespace jwts datafile size 1g;

Tablespace created.

orclz>