Changing default permenant USERS tablespace to bigfile
Change existing:

SQL&gt; create bigfile tablespace users2 datafile '/oradata/ORCL2/users.dbf' size 100M;

Tablespace created.

SQL&gt; alter database default tablespace users2;

Database altered.


Create new one:

DBCA allows you to choose bigfile tablespace for a Custom Database:



A "General Purpose" or "Data Warehouse" database is actually a pre-created database, there you do not have this option.

Or you can specify bigfile when creating a database with the CREATE DATABASE statement.