{"id":20976,"date":"2024-03-15T21:16:27","date_gmt":"2024-03-15T21:16:27","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/"},"modified":"2024-03-21T19:22:52","modified_gmt":"2024-03-21T19:22:52","slug":"how-to-create-a-tablespace-in-oracle-database","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/","title":{"rendered":"How to create a tablespace in Oracle Database?"},"content":{"rendered":"<p>To create a tablespace in Oracle database, you can use the following syntax:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span>SPACE tablespace_name\r\n  DATAFILE <span class=\"hljs-string\">'file_name'<\/span>\r\n  SIZE size\r\n  [AUTOEXTEND <span class=\"hljs-keyword\">ON<\/span> NEXT size]\r\n  [MAXSIZE size]\r\n  [EXTENT MANAGEMENT {<span class=\"hljs-keyword\">LOCAL<\/span> <span class=\"hljs-operator\">|<\/span> DICTIONARY}]\r\n  [SEGMENT SPACE MANAGEMENT {AUTO <span class=\"hljs-operator\">|<\/span> MANUAL}]\r\n  [<span class=\"hljs-keyword\">DEFAULT<\/span> STORAGE(storage_clause)]\r\n  [TEMPORARY]\r\n  [UNDO];\r\n<\/code><\/pre>\n<p>tablespace_name is the name of the tablespace to be created, file_name is the data file name of the tablespace, and size is the initial size of the tablespace. AUTOEXTEND ON NEXT parameter is used to specify the automatic extension size of the tablespace, MAXSIZE parameter is used to specify the maximum size of the tablespace. EXTENT MANAGEMENT is used to specify the management method of the tablespace, where DICTIONARY means using dictionary management and LOCAL means using local management. SEGMENT SPACE MANAGEMENT is used to specify the management method of segment space, where AUTO means automatic management and MANUAL means manual management. DEFAULT STORAGE is used to specify the default storage attributes of the tablespace. TEMPORARY is used to create a temporary tablespace, and UNDO is used to create an undo tablespace.<\/p>\n<p>For example, here is a sample of creating a tablespace named &#8220;my_tablespace&#8221;:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span>SPACE my_tablespace\r\n  DATAFILE <span class=\"hljs-string\">'\/u01\/app\/oracle\/oradata\/mydb\/my_tablespace.dbf'<\/span>\r\n  SIZE <span class=\"hljs-number\">100<\/span>M\r\n  AUTOEXTEND <span class=\"hljs-keyword\">ON<\/span> NEXT <span class=\"hljs-number\">10<\/span>M\r\n  MAXSIZE <span class=\"hljs-number\">500<\/span>M\r\n  EXTENT MANAGEMENT <span class=\"hljs-keyword\">LOCAL<\/span>\r\n  SEGMENT SPACE MANAGEMENT AUTO\r\n  <span class=\"hljs-keyword\">DEFAULT<\/span> STORAGE (<span class=\"hljs-keyword\">INITIAL<\/span> <span class=\"hljs-number\">1<\/span>M NEXT <span class=\"hljs-number\">1<\/span>M MINEXTENTS <span class=\"hljs-number\">1<\/span> MAXEXTENTS UNLIMITED);\r\n<\/code><\/pre>\n<p>This example creates a tablespace called &#8220;my_tablespace&#8221; with a data file located at &#8220;\/u01\/app\/oracle\/oradata\/mydb\/my_tablespace.dbf&#8221;. The initial size is set to 100MB, with automatic growth increment of 10MB and a maximum size of 500MB. It is configured to use local management and automatic segment space management. The default storage properties are initialized at 1MB, with the next incremental size at 1MB, minimum extension of 1 block, and maximum extension unlimited.<\/p>\n<p>Please adjust the grammar and parameters according to your actual needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To create a tablespace in Oracle database, you can use the following syntax: CREATE TABLESPACE tablespace_name DATAFILE &#8216;file_name&#8217; SIZE size [AUTOEXTEND ON NEXT size] [MAXSIZE size] [EXTENT MANAGEMENT {LOCAL | DICTIONARY}] [SEGMENT SPACE MANAGEMENT {AUTO | MANUAL}] [DEFAULT STORAGE(storage_clause)] [TEMPORARY] [UNDO]; tablespace_name is the name of the tablespace to be created, file_name is the data [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-20976","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to create a tablespace in Oracle Database? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create a tablespace in Oracle Database?\" \/>\n<meta property=\"og:description\" content=\"To create a tablespace in Oracle database, you can use the following syntax: CREATE TABLESPACE tablespace_name DATAFILE &#039;file_name&#039; SIZE size [AUTOEXTEND ON NEXT size] [MAXSIZE size] [EXTENT MANAGEMENT {LOCAL | DICTIONARY}] [SEGMENT SPACE MANAGEMENT {AUTO | MANUAL}] [DEFAULT STORAGE(storage_clause)] [TEMPORARY] [UNDO]; tablespace_name is the name of the tablespace to be created, file_name is the data [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T21:16:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T19:22:52+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How to create a tablespace in Oracle Database?\",\"datePublished\":\"2024-03-15T21:16:27+00:00\",\"dateModified\":\"2024-03-21T19:22:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\"},\"wordCount\":255,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\",\"name\":\"How to create a tablespace in Oracle Database? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T21:16:27+00:00\",\"dateModified\":\"2024-03-21T19:22:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a tablespace in Oracle Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to create a tablespace in Oracle Database? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"How to create a tablespace in Oracle Database?","og_description":"To create a tablespace in Oracle database, you can use the following syntax: CREATE TABLESPACE tablespace_name DATAFILE 'file_name' SIZE size [AUTOEXTEND ON NEXT size] [MAXSIZE size] [EXTENT MANAGEMENT {LOCAL | DICTIONARY}] [SEGMENT SPACE MANAGEMENT {AUTO | MANUAL}] [DEFAULT STORAGE(storage_clause)] [TEMPORARY] [UNDO]; tablespace_name is the name of the tablespace to be created, file_name is the data [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T21:16:27+00:00","article_modified_time":"2024-03-21T19:22:52+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How to create a tablespace in Oracle Database?","datePublished":"2024-03-15T21:16:27+00:00","dateModified":"2024-03-21T19:22:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/"},"wordCount":255,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/","name":"How to create a tablespace in Oracle Database? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T21:16:27+00:00","dateModified":"2024-03-21T19:22:52+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-tablespace-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to create a tablespace in Oracle Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=20976"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20976\/revisions"}],"predecessor-version":[{"id":54810,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20976\/revisions\/54810"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=20976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=20976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=20976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}