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.
