Oracle create tablespace

In this tutorial, How do I use Oracle create tablespace? Create multiple datafile with a single create tablespace.

Oracle Permanent tablespace

SQL> CREATE BIGFILE TABLESPACE USERDATA LOGGING DATAFILE '/mnt_nfs/oradata/oracle11g/DEVOPSROLES/USERDATA.dbf' size 2048MB EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Named datafile: USERDATA
where 2048M is the size of a datafile
Location: /mnt_nfs/oradata/oracle11g/DEVOPSROLES/USERDATA.dbf

Oracle Temporary tablespace

SQL> create temporary tablespace TEMP_DATA tempfile '/mnt_nfs/oradata/oracle11g/DEVOPSROLES/TEMP_DATA.dbf' size 32m autoextend on next 32m maxsize 1048m extent management local;

Note: A temporary tablespace has tempfiles, not datafiles.

Creating multiple datafile with a single create tablespace

create tablespace DATA 
datafile '/mnt_nfs/oradata/oracle11g/DEVOPSROLES/DATA_01.dbf' size 4M autoextend off,
'/mnt_nfs/oradata/oracle11g/DEVOPSROLES/DATA_02.dbf' size 4M autoextend off,
'/mnt_nfs/oradata/oracle11g/DEVOPSROLES/DATA_03.dbf' size 4M autoextend off
logging extent management local;

Conclusion

Thought the article, you have used Oracle create the tablespace. My topic another  “Install Oracle Database 12c on Centos 7”. I hope will this your helpful.