{"id":10679,"date":"2024-03-14T12:33:34","date_gmt":"2024-03-14T12:33:34","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/"},"modified":"2025-08-04T02:31:26","modified_gmt":"2025-08-04T02:31:26","slug":"what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/","title":{"rendered":"Oracle DROP TABLE: Release Space Immediately"},"content":{"rendered":"

In Oracle, when you use the DROP TABLE command to delete a table, the storage space occupied by the table is not released immediately. Instead, the table is moved to the recycle bin to prevent accidental data loss.<\/p>\n

If you wish to immediately free up the storage space occupied by the table, you can use the following method:<\/p>\n

    \n
  1. Permanently delete a table using the PURGE command: Adding the PURGE keyword after the DROP TABLE command will immediately delete the table and free up storage space. For example: DROP TABLE table_name PURGE;<\/li>\n
  2. Truncate a table using the ALTER TABLE command: You can truncate a table using the ALTER TABLE command to delete all data from the table while keeping the table structure intact. This helps to free up storage space while retaining the table structure. For example: ALTER TABLE table_name TRUNCATE;<\/li>\n
  3. Reallocate tablespace using the ALTER TABLE command: If you want to change the storage space used by a table, you can use the ALTER TABLE command to modify the storage options, such as adjusting the tablespace or storage parameters.<\/li>\n<\/ol>\n

    Please make sure to backup your data before performing the above operation to prevent any accidental deletion or modification that may result in data loss.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In Oracle, when you use the DROP TABLE command to delete a table, the storage space occupied by the table is not released immediately. Instead, the table is moved to the recycle bin to prevent accidental data loss. If you wish to immediately free up the storage space occupied by the table, you can use […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[6198,813,13442,13443,3166],"class_list":["post-10679","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-drop-table","tag-oracle-database","tag-purge-command","tag-space-management","tag-storage-space"],"yoast_head":"\nOracle DROP TABLE: Release Space Immediately - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.\" \/>\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\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle DROP TABLE: Release Space Immediately\" \/>\n<meta property=\"og:description\" content=\"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\" \/>\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-14T12:33:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T02:31:26+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\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=\"Ava Mitchell\" \/>\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:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Oracle DROP TABLE: Release Space Immediately\",\"datePublished\":\"2024-03-14T12:33:34+00:00\",\"dateModified\":\"2025-08-04T02:31:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\"},\"wordCount\":212,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"DROP TABLE\",\"Oracle database\",\"PURGE command\",\"Space management\",\"Storage space\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\",\"name\":\"Oracle DROP TABLE: Release Space Immediately - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T12:33:34+00:00\",\"dateModified\":\"2025-08-04T02:31:26+00:00\",\"description\":\"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle DROP TABLE: Release Space Immediately\"}]},{\"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle DROP TABLE: Release Space Immediately - Blog - Silicon Cloud","description":"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.","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\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle DROP TABLE: Release Space Immediately","og_description":"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.","og_url":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T12:33:34+00:00","article_modified_time":"2025-08-04T02:31:26+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Oracle DROP TABLE: Release Space Immediately","datePublished":"2024-03-14T12:33:34+00:00","dateModified":"2025-08-04T02:31:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/"},"wordCount":212,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["DROP TABLE","Oracle database","PURGE command","Space management","Storage space"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/","name":"Oracle DROP TABLE: Release Space Immediately - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T12:33:34+00:00","dateModified":"2025-08-04T02:31:26+00:00","description":"Learn how to properly release storage space after dropping tables in Oracle using the PURGE command for immediate space recovery.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-should-be-done-if-space-is-not-released-after-dropping-a-table-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle DROP TABLE: Release Space Immediately"}]},{"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10679","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=10679"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10679\/revisions"}],"predecessor-version":[{"id":154445,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10679\/revisions\/154445"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=10679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=10679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=10679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}