{"id":543,"date":"2018-06-29T21:49:27","date_gmt":"2018-06-29T21:49:27","guid":{"rendered":"http:\/\/dbtut.com\/?p=543"},"modified":"2020-10-17T20:17:54","modified_gmt":"2020-10-17T20:17:54","slug":"how-to-create-tablespace-on-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/","title":{"rendered":"How To Create Tablespace On Oracle"},"content":{"rendered":"<p>Tablespaces are areas dedicated to storing objects in the database.<\/p>\n<p>Tablespaces are logical constructs. However, it contains physical data files or temp files.<\/p>\n<p>There are three different tablespace types on Oracle.<\/p>\n<ol>\n<li>Permanent Tablespace<\/li>\n<li>Temporary Tablespace<\/li>\n<li>Undo Tablespace<\/li>\n<\/ol>\n\n<h3>Permanent Tablepace:<\/h3>\n<p>Permanent tablespaces are the types of tablespaces used to hold data in a database. There are two kinds of permanent tablespace.<\/p>\n<ul>\n<li>bigfile tablespace<\/li>\n<li>smallfile tablespace<\/li>\n<\/ul>\n<h3>Bigfile Tablespace:<\/h3>\n<p>There is only one data file or temp file in the bigfile tablespace.<\/p>\n<p>If the block size is 32K, the maximum size of this data file or temp file can be 128TB.<\/p>\n<p>If the block size is 8K, the maximum size of this data file or temp file can be 32TB.<\/p>\n<p>EXTENT MANAGEMENT DICTIONARY can not be used on bigfile tablespaces.<\/p>\n<h3>Smallfile Tablespace:<\/h3>\n<p>The oracle tablespaces we know. You can create 1022 data files in a smallfile tablespace.<\/p>\n<p>If the block size is 32K, the maximum size of this data file or temp file can be 128GB.<\/p>\n<p>If the block size is 8K, the maximum size of this data file or temp file can be 32GB.<\/p>\n<p>Below you can see examples and explanations about creating a tablespace.<\/p>\n<h3>Example1(Smallfile Tablespace):<\/h3>\n<p>In the following example, we create a smallfile tablespace containing 9 data files.<\/p>\n<p>The meanings of the parameters in the script can be found in the following table.<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 242.4px;\">TABLESPACE_NAME<\/td>\n<td style=\"width: 440.8px;\">You should write the name of the tablespace here.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">DISKGROUP_NAME<\/td>\n<td style=\"width: 440.8px;\">You should write the diskgroup name here that you want to keep the datafile in ASM.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">1024K<\/td>\n<td style=\"width: 440.8px;\">Datafile&#8217;s initial size<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">AUTOEXTEND ON<\/td>\n<td style=\"width: 440.8px;\">We set datafile to grow automatically.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">NEXT 100M<\/td>\n<td style=\"width: 440.8px;\">We specify that each automatic growth will be 100M.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">MAXSIZE UNLIMITED<\/td>\n<td style=\"width: 440.8px;\">We set the datafile&#8217;s maximum size to unlimited.<\/p>\n<p>But as I mentioned earlier, small datafiles can grow up to 128GB even if you set MAXSIZE to UNLIMITED.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">LOGGING<\/td>\n<td style=\"width: 440.8px;\">This specifies that each object that will be created in the tablespace will be in LOGGING mode by default.<\/p>\n<p>For details, you can read the article &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/10\/what-is-logging_clause-on-oraclelogging-or-nologging\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is\u00a0 logging_clause On Oracle(LOGGING or NOLOGGING)<\/a>&#8220;.<\/p>\n<p>This parameter is not available for Temporary and Undo tablespaces.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">ONLINE<\/td>\n<td style=\"width: 440.8px;\">You can set the tablespace to be online or offline using the ONLINE or OFFLINE parameters.<\/p>\n<p>Can not be used for Temporary tablespace.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">EXTENT MANAGEMENT LOCAL AUTOALLOCATE<\/td>\n<td style=\"width: 440.8px;\">Extent Management determines how extents are managed.<\/p>\n<p>If you specify LOCAL, it is managed locally.<\/p>\n<p>If you specify DICTIONARY, extent management is managed using dictionary tables.<\/p>\n<p>In Oracle 9i, LOCAL becomes default.<\/p>\n<p>We recommend using it this way.<\/p>\n<p>For details, you might want to read the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/17\/how-to-check-if-there-is-a-dictionary-managed-tablespace-on-oracle-databaseextent-management-control\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database<\/a>&#8220;.<\/p>\n<p>By specifying AUTOALLOCATE, we specify that the extent management process will be managed automatically.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">BLOCKSIZE 32K<\/td>\n<td style=\"width: 440.8px;\">This means that the Tablespace&#8217;s Block size is 32K.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">SEGMENT SPACE MANAGEMENT AUTO<\/td>\n<td style=\"width: 440.8px;\">This statement can only be used for permanent tablespaces that have the extent management parameter defined as local.<\/p>\n<p>You can monitor the used and empty fields in the segments with this parameter.<\/p>\n<p>If you set it to AUTO, ORACLE will do it for you. We recommend using it this way.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 242.4px;\">FLASHBACK ON<\/td>\n<td style=\"width: 440.8px;\">The FLASBACK parameter can be set to ON or OFF.<\/p>\n<p>Default is FLASBACK ON. This way, this tablespace works in FLASHBACK mode.<\/p>\n<p>For details you can read the article &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/13\/what-is-flasback-database-and-how-to-flashback\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is FLASBACK DATABASE and How To FLASHBACK Oracle Database<\/a>&#8220;.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre class=\"lang:default decode:true \">CREATE TABLESPACE TABLESPACE_NAME DATAFILE \r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,\r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\r\nLOGGING\r\nONLINE\r\nEXTENT MANAGEMENT LOCAL AUTOALLOCATE\r\nBLOCKSIZE 32K\r\nSEGMENT SPACE MANAGEMENT AUTO\r\nFLASHBACK ON;<\/pre>\n\n<h3>Example2(Bigfile Tablespace);<\/h3>\n<p>In the following example, we create a bigfile tablespace containing 1 data file.<\/p>\n<p>The meanings of the parameters in the script can be found in the table above.<\/p>\n<pre class=\"lang:default decode:true \">CREATE BIGFILE TABLESPACE TABLESPACE_NAME DATAFILE \r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\r\nLOGGING\r\nONLINE\r\nEXTENT MANAGEMENT LOCAL AUTOALLOCATE\r\nBLOCKSIZE 32K\r\nSEGMENT SPACE MANAGEMENT AUTO\r\nFLASHBACK ON;<\/pre>\n<h3>Example3(Temporary Tablespace):<\/h3>\n<p>You can create an example temp tablespace with the following script.<\/p>\n<table>\n<tbody>\n<tr>\n<td>UNIFORM SIZE 1M<\/td>\n<td>1 Mb&#8217;l\u0131k Uniform Extenler olaca\u011f\u0131n\u0131 belirtir.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre class=\"lang:default decode:true\">CREATE TEMPORARY TABLESPACE TABLESPACE_NAME TEMPFILE \r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\r\nTABLESPACE GROUP ''\r\nEXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;<\/pre>\n<p>In some cases, you may need to move the Temp Tablespace to another diskgroup.<\/p>\n<p>To do this online, I recommend you read the article &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/16\/how-to-move-the-temp-tablespace-to-another-diskgroup-on-oracle\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Move The Temp Tablespace to Another Diskgroup On Oracle<\/a>&#8220;.<\/p>\n\n<h3>Example4(UNDO Tablespace):<\/h3>\n<p>If Undo Management is done automatically in the database, a tablespace will be assigned automatically for undo.<\/p>\n<p>Therefore, if the database is in automatic undo management mode, undo tablespace is not created manually.<\/p>\n<p>If the database is not in automatic undo management mode then SYSTEM Rollback segment is used.<\/p>\n<p>In such a case, you can manually create an undo segment using the following script.<\/p>\n<p>But I insist that you get the database into automatic undo management mode.<\/p>\n<table style=\"width: 692px;\">\n<tbody>\n<tr>\n<td style=\"width: 149px;\">RETENTION NOGUARANTEE<\/td>\n<td style=\"width: 543px;\">If you use the RETENTION NOGUARANTEE statement, unexpired data in undo segments can be used by subsequent transactions.<\/p>\n<p>In some cases some queries may take snapshot too old error. You can find the details in the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/04\/ora-01555-snapshot-too-old-ora-30036-unable-to-extend-segment-by-string-in-undo-tablespace\/\" target=\"_blank\" rel=\"noopener noreferrer\">ORA-01555 Snapshot Too Old<\/a>&#8220;.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre class=\"lang:default decode:true \">CREATE UNDO TABLESPACE TABLESPACE_NAME DATAFILE \r\n'+DISKGROUP_NAME' SIZE 1024K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\r\nONLINE\r\nRETENTION NOGUARANTEE\r\nBLOCKSIZE 32K\r\nFLASHBACK ON;<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_543\" class=\"pvc_stats all  \" data-element-id=\"543\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are three different tablespace types on Oracle. Permanent Tablespace Temporary Tablespace Undo Tablespace Permanent Tablepace: Permanent tablespaces are the types of tablespaces used to hold data in a database. There are &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_543\" class=\"pvc_stats all  \" data-element-id=\"543\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[602,603,612,534,617,599,601,622,593,581,605,614,613,608,604,611,615,610,609,621,592,596,620,619,600,409,607,606,597,618,598,616,594,595],"class_list":["post-543","post","type-post","status-publish","format-standard","","category-oracle","tag-32k","tag-8k","tag-autoallocate","tag-autoextend","tag-automatic-undo-management","tag-bigfile-tablespace","tag-block-size","tag-blocksize","tag-create-oracle-tablespace","tag-create-tablespace","tag-data-file","tag-dictionary-tables","tag-dictionary-managed","tag-diskgroup_name","tag-extent-management-dictionary","tag-extent-management-local","tag-flashback","tag-logging","tag-maxsize","tag-ora-01555-snapshot-too-old","tag-oracle-tablespace","tag-permanent-tablespace","tag-retention-guarantee","tag-retention-noguarantee","tag-smallfile-tablespace","tag-tablespace","tag-tablespace_name","tag-temp-file","tag-temporary-tablespace","tag-undo-management","tag-undo-tablespace","tag-uniform-size","tag-what-is-oracle-tablespace","tag-what-is-tablespace"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":10435,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Tablespace On Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create Tablespace On Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Tablespace On Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create Tablespace On Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-29T21:49:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-17T20:17:54+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create Tablespace On Oracle\",\"datePublished\":\"2018-06-29T21:49:27+00:00\",\"dateModified\":\"2020-10-17T20:17:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\"},\"wordCount\":785,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"32K\",\"8K\",\"AUTOALLOCATE\",\"autoextend\",\"automatic undo management\",\"bigfile tablespace\",\"block size\",\"BLOCKSIZE\",\"create oracle tablespace\",\"Create tablespace\",\"data file\",\"dictionary tables\",\"Dictionary-Managed\",\"DISKGROUP_NAME\",\"EXTENT MANAGEMENT DICTIONARY\",\"EXTENT MANAGEMENT LOCAL\",\"FLASHBACK\",\"LOGGING\",\"MAXSIZE\",\"ORA-01555 Snapshot Too Old\",\"oracle tablespace\",\"permanent tablespace\",\"RETENTION GUARANTEE\",\"RETENTION NOGUARANTEE\",\"smallfile tablespace\",\"TABLESPACE\",\"TABLESPACE_NAME\",\"temp file\",\"temporary tablespace\",\"undo management\",\"undo tablespace\",\"UNIFORM SIZE\",\"what is oracle tablespace\",\"what is tablespace\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\",\"name\":\"How To Create Tablespace On Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-06-29T21:49:27+00:00\",\"dateModified\":\"2020-10-17T20:17:54+00:00\",\"description\":\"How To Create Tablespace On Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Tablespace On Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create Tablespace On Oracle - Database Tutorials","description":"How To Create Tablespace On Oracle","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:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Tablespace On Oracle - Database Tutorials","og_description":"How To Create Tablespace On Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-29T21:49:27+00:00","article_modified_time":"2020-10-17T20:17:54+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create Tablespace On Oracle","datePublished":"2018-06-29T21:49:27+00:00","dateModified":"2020-10-17T20:17:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/"},"wordCount":785,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["32K","8K","AUTOALLOCATE","autoextend","automatic undo management","bigfile tablespace","block size","BLOCKSIZE","create oracle tablespace","Create tablespace","data file","dictionary tables","Dictionary-Managed","DISKGROUP_NAME","EXTENT MANAGEMENT DICTIONARY","EXTENT MANAGEMENT LOCAL","FLASHBACK","LOGGING","MAXSIZE","ORA-01555 Snapshot Too Old","oracle tablespace","permanent tablespace","RETENTION GUARANTEE","RETENTION NOGUARANTEE","smallfile tablespace","TABLESPACE","TABLESPACE_NAME","temp file","temporary tablespace","undo management","undo tablespace","UNIFORM SIZE","what is oracle tablespace","what is tablespace"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/","name":"How To Create Tablespace On Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-06-29T21:49:27+00:00","dateModified":"2020-10-17T20:17:54+00:00","description":"How To Create Tablespace On Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/29\/how-to-create-tablespace-on-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Tablespace On Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/543\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}