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;
