Oracle Recyclebin 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 dependant 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;

you have tables called emp and dept


3) now delete dept table

4) Issue the command select * from tab;

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

6) Now recover table dept from recyclebin

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


Thanks
Sagar