How to use Oracle Recycle bin Utility

Oracle Recycle bin Utility

Oracle has introduced "Recycle Bin" Feature Oracle 10g to store all the dropped objects. 
If any table in Oracle 10g is dropped then any associated objects to this table such as indexes, 
constraints and other dependent objects are simply renamed with a prefix of BIN$$.


Testing


Go to SQL*PLUS


1) connect to database

2)  Issue the command select * from tab;

3) Now we will delete DEPT table

4) Issue the command select * from tab;

5) Issue the command as shown in figure to check tables in Recycle bin

6) Now recover table DEPT from Recycle bin

7) Now check your table successfully recovered

This is use of recycle bin.

If you really don't want that table. Before flashback. Just  issue following command.
your tables will deleted permanently

SQL > PURGE RECYCLEBIN