{"id":33760,"date":"2023-05-05T02:55:22","date_gmt":"2023-05-05T02:55:22","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=33760"},"modified":"2023-05-05T02:55:24","modified_gmt":"2023-05-05T02:55:24","slug":"oracle-tutorials-what-is-difference-between-tablesapce-and-schema-in-oracle","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/oracle-tutorials-what-is-difference-between-tablesapce-and-schema-in-oracle\/","title":{"rendered":"Oracle Tutorials: What is difference between tablesapce and schema in oracle"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"481\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-7.png\" alt=\"\" class=\"wp-image-33764\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-7.png 795w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-7-300x182.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-7-768x465.png 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure>\n\n\n\n<p>In Oracle, a schema is a logical container that stores database objects such as tables, views, indexes, sequences, procedures, functions, etc. A schema is owned by a database user, and the user can manipulate and manage the schema objects. In other words, a schema is a collection of objects that belong to a user.<\/p>\n\n\n\n<p>On the other hand, a tablespace is a physical storage location that stores the database objects. A tablespace can contain multiple database objects, and multiple tablespaces can be created within a database. Tablespaces are used to control the allocation and use of disk space for database storage.<\/p>\n\n\n\n<p>To summarize, a schema is a logical container for database objects owned by a user, whereas a tablespace is a physical storage location for database objects. A schema is a logical entity, while a tablespace is a physical entity. In Oracle, a user can have multiple schemas, but a schema can only be owned by one user. Similarly, a tablespace can contain objects from different schemas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1021\" height=\"853\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-4.png\" alt=\"\" class=\"wp-image-33761\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-4.png 1021w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-4-300x251.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-4-768x642.png 768w\" sizes=\"auto, (max-width: 1021px) 100vw, 1021px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-5-1024x504.png\" alt=\"\" class=\"wp-image-33762\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-5-1024x504.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-5-300x148.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-5-768x378.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-5.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"351\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-6-1024x351.png\" alt=\"\" class=\"wp-image-33763\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-6-1024x351.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-6-300x103.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-6-768x264.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2023\/05\/image-6.png 1192w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle, a schema is a logical container that stores database objects such as tables, views, indexes, sequences, procedures, functions, etc. A schema is owned by a database user, and the user can manipulate and manage the schema objects. In other words, a schema is a collection of objects that belong to a user. On&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-33760","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=33760"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33760\/revisions"}],"predecessor-version":[{"id":33765,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33760\/revisions\/33765"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=33760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=33760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=33760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}