Changing default permenant USERS tablespace to bigfile I'm trying to build an oracle database server but it's setting up the users tablespace as a smallfile.   How can I either install brand new database with users being bigfile or changing the existing 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.