---
title: Issues With Oracle's Recyclebin
description: Take a closer look at how Oracle's recyclebin works and how to avoid the recyclebin storage
---

[Mertech Blog ](https://www.mertech.com/blog)

# [Issues With Oracle's Recyclebin](https://www.mertech.com/blog/issues-with-oracles-recyclebin)

 Written by [Mertech](https://www.mertech.com/blog/author/mertech) | Feb 24, 2008 11:25:00 PM

Since 10g Oracle introduced a new feature known as the Database Recyclebin. As an Operative System, recyclebin brings the ability to restore tables (files in OS) that are dropped (deleted).

### ** How Does Oracle's Recyclebin Work?**

If you drop a table in Oracle and the recyclebin is enabled then the table won't be deleted it will be *renamed* to a special name in the recyclebin object:

First, clean the recyclebin so you can see the new items in there:

**PURGE** recyclebin;  
Drop the table:

**DROP TABLE** test;  
To see it in the recyclebin type:

**SELECT * FROM** recyclebin;  
You will see an output with all the objects in table test that were renamed so they can be restored.

### To avoid the recyclebin *storage* you can do two things:

1. Purge your table when you DROP it:  
**  
DROP TABLE** test **PURGE**;  
2. Disable the recyclebin during your oracle session:

**ALTER SESSION SET** recyclebin = OFF;

**  
Issues With Recyclebin**

At the time I'm writing this article, Oracle 11g is the latest Oracle version, the current version is:

Oracle Database 11g Release 1 (11.1.0.6.0)

We are getting slowdowns with 11g and *not with 10g*, a 100+ columns table drop operation when the recyclebin is on is from 8~10 seconds. That very same operation with PURGE(or when the recyclebin is set OFF) does not take even a second to finish.

For more information about Oracle's recyclebin visit: [http://www.orafaq.com/node/968

](http://www.orafaq.com/node/968)

[View full post](https://www.mertech.com/blog/issues-with-oracles-recyclebin)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Mertech"
  },
  "dateModified" : "2018-02-27T16:48:39.973Z",
  "datePublished" : "2008-02-24T23:25:00Z",
  "headline" : "Issues With Oracle's Recyclebin",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.mertech.com/blog/issues-with-oracles-recyclebin",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```