How to create Bigfile tablespace for EXADATA DB MACHINES and Other high end DW systems

How to create Bigfile tablespace for EXADATA DB MACHINES and Other high end DW systems?

Traditionally we use small file tablespace which can handle data upto a maxsize of 32GB.

However Big file tablespaces are required when we want to create tablespace with more than 32 GB size.

This is very help when we work on Oracle High end Advance Database machine like Exadata and also for various DataWarehouse systems.

CREATE BIGFILE TABLESPACE EDW_DATA_EQBS DATAFILE '+DATABIPRD' SIZE 512G AUTOEXTEND ON; -- done 


CREATE BIGFILE TABLESPACE EDW_DATA_FOUNDATION DATAFILE '+DATABIPRD' SIZE 512G AUTOEXTEND ON;


CREATE BIGFILE TABLESPACE EDW_DATA_DRE DATAFILE '+DATABIPRD' SIZE 512G AUTOEXTEND ON;


CREATE BIGFILE TABLESPACE EDW_METADATA_TOOLS DATAFILE '+DATABIPRD' SIZE 128G AUTOEXTEND ON;




CREATE BIGFILE TEMPORARY TABLESPACE TEMP TEMPFILE '+DATABIPRD' SIZE 256G AUTOEXTEND ON;


CREATE BIGFILE TEMPORARY TABLESPACE TEMP1 TEMPFILE '+DATABIPRD' SIZE 256G AUTOEXTEND ON;


CREATE BIGFILE TEMPORARY TABLESPACE TEMP2 TEMPFILE '+DATABIPRD' SIZE 256G AUTOEXTEND ON;


CREATE BIGFILE TEMPORARY TABLESPACE TEMP3 TEMPFILE '+DATABIPRD' SIZE 256G AUTOEXTEND ON;


CREATE BIGFILE TEMPORARY TABLESPACE TEMP4 TEMPFILE '+DATABIPRD' SIZE 256G AUTOEXTEND ON;



ALTER TABLESPACE EDW_METADATA_TOOLS AUTOEXTEND ON NEXT 8G MAXSIZE 512G;

ALTER TABLESPACE EDW_DATA_EQBS AUTOEXTEND ON NEXT 8G MAXSIZE 1024G;

ALTER TABLESPACE EDW_DATA_FOUNDATION AUTOEXTEND ON NEXT 8G MAXSIZE 1024G;

ALTER TABLESPACE EDW_DATA_DRE AUTOEXTEND ON NEXT 8G MAXSIZE 1024G;



ALTER TABLESPACE TEMP AUTOEXTEND ON NEXT 8G MAXSIZE 512G;

ALTER TABLESPACE TEMP1 AUTOEXTEND ON NEXT 8G MAXSIZE 512G;

ALTER TABLESPACE TEMP2 AUTOEXTEND ON NEXT 8G MAXSIZE 512G;

ALTER TABLESPACE TEMP3 AUTOEXTEND ON NEXT 8G MAXSIZE 512G;

ALTER TABLESPACE TEMP4 AUTOEXTEND ON NEXT 8G MAXSIZE 512G;