How to Create a Tablespace in Oracle

From time to time you’ll need to create a new tablespace in your Oracle database.

Here is how to create a tablespace in Oracle.

Permanent tablespace

CREATE tablespace TS_APP_DAT datafile '+DATA'
size 1G AUTOEXTEND ON NEXT 500M MAXSIZE 25G;

Temporary tablespace

CREATE temporary tablespace TS_TEMP tempfile '+DATA'
size 1G AUTOEXTEND ON NEXT 500M MAXSIZE 5G;

Undo tablespace

CREATE undo tablespace TS_UNDO datafile '+DATA'
size 3G;

Leave a Reply

Your email address will not be published. Required fields are marked *