1 minutes readRecycle Bin (Part-4)

A recycle bin contains all the dropped database objects and their dependent objects.

Note:

• We can drop it immediately and permanently with purge option (DROP TABLE emp PURGE)
• We can view the dropped objects in the recycle bin from two dictionary views:
  USER_RECYCLEBIN — list all dropped user objects.
  DBA_RECYCLEBIN — list all dropped system-wide objects

Viewing the original name of dropped objects?

SQL> SELECT object_name as recycle_name, original_name, object_type FROM recyclebin;

How to remove table from recycle bin?

SQL> purge table “BIN$0+ktoVChEmXgNAAADiUEHQ==$0”;

How to purge recycle bin?

SQL> purge recyclebin;

How to purge all objects from the recycle bin?

SQL> purge dba_recyclebin;

How to purge all objects from tablespace in the recycle bin?

SQL> purge tablespace users;