{"id":57400,"date":"2025-01-05T19:20:41","date_gmt":"2025-01-05T19:20:41","guid":{"rendered":"https:\/\/dbtut.com\/?p=57400"},"modified":"2025-01-05T19:20:41","modified_gmt":"2025-01-05T19:20:41","slug":"increasing-tablespace-in-oracle-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/","title":{"rendered":"Increasing Tablespace In Oracle Database"},"content":{"rendered":"
\n
\n
\n
\n
In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

When increasing the tablespace size, it is important to review the available disk space where our data files are stored.<\/p>\n

Checking the size of Disk Groups:<\/h4>\n

If we are using ASM (Automatic Storage Management), the size can be determined as follows:<\/p>\n

\tSQL>    select name, total_mb, free_mb from v$asm_diskgroup;\r\n\t\r\n\tNAME                             TOTAL_MB    FREE_MB\r\n\t------------------------------ ---------- ----------\r\n\tDATA                              2047890     911156\r\n\tFRA                               1638312    1391308\r\n\tOCRVOTE                             61437      60511\r\n<\/pre>\n
2. If we are using Single Node, we look at where our data files are.<\/p>\n
\t-bash-3.2$ ll cd \/oracle\/ora11g\/data_ONURDB\/ONURDB\/*.dbf\r\n\tls: cd: No such file or directory\r\n\t-rw-r----- 1 oracle oinstall 1073750016 Jun 25 14:19 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/hr_bigts.dbf\r\n\t-rw-r----- 1 oracle oinstall 1073750016 Jun 25 16:42 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/hr_data.dbf\r\n\t-rw-r----- 1 oracle oinstall  943726592 Jun 25 16:57 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/sysaux01.dbf\r\n\t-rw-r----- 1 oracle oinstall 1184899072 Jun 25 16:57 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/system01.dbf\r\n\t-rw-r----- 1 oracle oinstall   20979712 Jun 25 12:46 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/temp01.dbf\r\n\t-rw-r----- 1 oracle oinstall  812654592 Jun 25 16:57 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/undotbs01.dbf\r\n\t-rw-r----- 1 oracle oinstall   20979712 Jun 25 14:42 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/undotbs02.dbf\r\n\t-rw-r----- 1 oracle oinstall  110108672 Jun 25 03:18 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/users01.dbf\r\n\t-rw-r----- 1 oracle oinstall 1073750016 Jun 25 03:18 \/oracle\/ora11g\/data_ONURDB\/ONURDB\/webtvnew01.dbf\r\n\t\r\n\t-bash-3.2$ df -h \/oracle\/ora11g\/data_ONURDB\/ONURDB\/\r\n\tFilesystem            Size  Used Avail Use% Mounted on\r\n\t\/dev\/sda3              45G   29G   14G  69% \/\r\n<\/pre>\n
After this information, the data file is added.<\/p>\n
This process is done in 2 ways. The first is adding a new data file, the second is expanding the data file.<\/p>\n
1. Adding a data file<\/p>\n
\tSQL> ALTER TABLESPACE WEBTVNEW ADD DATAFILE '\/oracle\/ora11g\/data_ONURDB\/ONURDB\/webtvnew02.dbf' SIZE 20M;\r\n\t\r\n\tTablespace altered.\r\n<\/pre>\n
2. Expanding the Existing Data File<\/p>\n
\tSQL> ALTER DATABASE DATAFILE '\/oracle\/ora11g\/data_ONURDB\/ONURDB\/webtvnew01.dbf' RESIZE 20M;\r\n\t\r\nDatabase altered.<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups. When increasing the tablespace size, it is important to review the available disk space where our data files are stored. Checking the size of Disk Groups: If we are using ASM (Automatic …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":57401,"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":[],"class_list":["post-57400","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nIncreasing Tablespace In Oracle Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.\" \/>\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\/2025\/01\/05\/increasing-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=\"Increasing Tablespace In Oracle Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-05T19:20:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png\" \/>\n\t<meta property=\"og:image:width\" content=\"695\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Increasing Tablespace In Oracle Database\",\"datePublished\":\"2025-01-05T19:20:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\"},\"wordCount\":122,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\",\"name\":\"Increasing Tablespace In Oracle Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png\",\"datePublished\":\"2025-01-05T19:20:41+00:00\",\"description\":\"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png\",\"width\":695,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Increasing Tablespace In Oracle Database\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Increasing Tablespace In Oracle Database - Database Tutorials","description":"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.","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\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Increasing Tablespace In Oracle Database - Database Tutorials","og_description":"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.","og_url":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/","og_site_name":"Database Tutorials","article_published_time":"2025-01-05T19:20:41+00:00","og_image":[{"width":695,"height":273,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Increasing Tablespace In Oracle Database","datePublished":"2025-01-05T19:20:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/"},"wordCount":122,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/","url":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/","name":"Increasing Tablespace In Oracle Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png","datePublished":"2025-01-05T19:20:41+00:00","description":"In today\u2019s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2025\/01\/Ekran-goruntusu-2025-01-05-221049.png","width":695,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2025\/01\/05\/increasing-tablespace-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Increasing Tablespace In Oracle Database"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57400","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=57400"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57400\/revisions"}],"predecessor-version":[{"id":57402,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57400\/revisions\/57402"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/57401"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=57400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=57400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=57400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}