CREATE BIGFILE TABLESPACE smpl_data
DATAFILE ‘/tmp/smpl_data.df’ SIZE 10M BLOCKSIZE 8K
AUTOEXTEND ON NEXT 10M MAXSIZE 2000GB;

CREATE TEMPORARY TABLESPACE temp_demo
TEMPFILE ‘temp01.dbf’ SIZE 5M AUTOEXTEND ON;

CREATE UNDO TABLESPACE undots1
DATAFILE ‘undotbs_1a.dbf’
SIZE 10M AUTOEXTEND ON
RETENTION GUARANTEE;