Oracle create tablespace

In this tutorial, How do I use Oracle create the 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.

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

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

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.