{"id":56072,"date":"2024-04-02T11:54:13","date_gmt":"2024-04-02T11:54:13","guid":{"rendered":"https:\/\/dbtut.com\/?p=56072"},"modified":"2024-04-02T12:02:35","modified_gmt":"2024-04-02T12:02:35","slug":"how-to-growth-oracle-tablespace","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/","title":{"rendered":"How To Growth Oracle Tablespace"},"content":{"rendered":"

In today’s article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups.<\/p>\n

While growing the tablespace, we need to review our disk space where our data files are stored.<\/p>\n

Learning the sizes of Disk Groups.<\/h4>\n

1. If we use ASM, we learn 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\nOCRVOTE                             61437      60511<\/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 1st is to add a new data file, the 2nd is to grow the data file.<\/p>\n
1. Adding data file.<\/p>\n
SQL> ALTER TABLESPACE WEBTVNEW ADD DATAFILE '\/oracle\/ora11g\/data_ONURDB\/ONURDB\/webtvnew02.dbf' SIZE 20M;\r\n\t\r\nTablespace altered.\r\n<\/pre>\n
2. Enlarging the growing Data File.<\/p>\n
\tSQL> ALTER DATABASE DATAFILE '\/oracle\/ora11g\/data_ONURDB\/ONURDB\/webtvnew01.dbf' RESIZE 20M;\r\n\t\r\n\tDatabase altered.\r\n<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups. While growing the tablespace, we need to review our disk space where our data files are stored. Learning the sizes of Disk Groups. 1. If we use ASM, we learn as follows. SQL> select name, …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":56074,"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-56072","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nHow To Growth Oracle Tablespace - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of 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\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Growth Oracle Tablespace - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-02T11:54:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-02T12:02:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png\" \/>\n\t<meta property=\"og:image:width\" content=\"683\" \/>\n\t<meta property=\"og:image:height\" content=\"259\" \/>\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\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"How To Growth Oracle Tablespace\",\"datePublished\":\"2024-04-02T11:54:13+00:00\",\"dateModified\":\"2024-04-02T12:02:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\"},\"wordCount\":109,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\",\"name\":\"How To Growth Oracle Tablespace - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png\",\"datePublished\":\"2024-04-02T11:54:13+00:00\",\"dateModified\":\"2024-04-02T12:02:35+00:00\",\"description\":\"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png\",\"width\":683,\"height\":259},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Growth Oracle Tablespace\"}]},{\"@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":"How To Growth Oracle Tablespace - Database Tutorials","description":"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of 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\/2024\/04\/02\/how-to-growth-oracle-tablespace\/","og_locale":"en_US","og_type":"article","og_title":"How To Growth Oracle Tablespace - Database Tutorials","og_description":"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/","og_site_name":"Database Tutorials","article_published_time":"2024-04-02T11:54:13+00:00","article_modified_time":"2024-04-02T12:02:35+00:00","og_image":[{"width":683,"height":259,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.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\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"How To Growth Oracle Tablespace","datePublished":"2024-04-02T11:54:13+00:00","dateModified":"2024-04-02T12:02:35+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/"},"wordCount":109,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/","url":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/","name":"How To Growth Oracle Tablespace - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png","datePublished":"2024-04-02T11:54:13+00:00","dateModified":"2024-04-02T12:02:35+00:00","description":"In today's article, we will be discussing How to Growth Tablespace in Oracle after learning the sizes of Disk Groups.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/04\/Ekran-goruntusu-2024-04-02-144859.png","width":683,"height":259},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/04\/02\/how-to-growth-oracle-tablespace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Growth Oracle Tablespace"}]},{"@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\/56072","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=56072"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56072\/revisions"}],"predecessor-version":[{"id":56073,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56072\/revisions\/56073"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56074"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}