{"id":24,"date":"2006-10-14T17:47:12","date_gmt":"2006-10-14T17:47:12","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2006\/10\/14\/oracle-recycle-bin-flashback-table-feature\/"},"modified":"2011-05-26T22:48:08","modified_gmt":"2011-05-26T22:48:08","slug":"oracle-recycle-bin-flashback-table-feature","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=24","title":{"rendered":"Oracle recycle bin flashback table feature"},"content":{"rendered":"<div class=\"entry\">When you do \u00e2\u20ac\u02dcSelect * from tab;\u00e2\u20ac\u2122 some times, you will be surprised to see some tables with garbage names. Welcome to the world of Oracle Recycle Bin Feature. Because of this feature, Oracle saves the dropped table in recycle bins until you clear it.<br \/>\n1. Empty recycle bin use the command:<br \/>\n<strong><em>PURGE RECYCLEBIN<\/em>;<\/strong><br \/>\n2. To drop the table without storing the table in recycle bin use:<br \/>\n<em><strong>DROP TABLE employee PURGE;<\/strong><\/em><br \/>\n3. To restore the table from the recycle bin use:<br \/>\n<em><strong>FLASHBACK TABLE employee TO BEFORE DROP;<\/strong><\/em><br \/>\n<em><strong>So don\u00e2\u20ac\u2122t forget to clean your database \/Schema once in a while.<\/strong><\/em><\/div>\n","protected":false},"excerpt":{"rendered":"<p>When you do \u00e2\u20ac\u02dcSelect * from tab;\u00e2\u20ac\u2122 some times, you will be surprised to see some tables with garbage names. Welcome to the world of Oracle Recycle Bin Feature. Because of this feature, Oracle saves the dropped table in recycle bins until you clear it. 1. Empty recycle bin use the command: PURGE RECYCLEBIN; 2. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,1],"tags":[],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-oracle","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24"}],"version-history":[{"count":5,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/24\/revisions"}],"predecessor-version":[{"id":217,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/24\/revisions\/217"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}