Oracle Database - Recycle Bin (Flashback Drop)

When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time.

SELECT * FROM RECYCLEBIN;

DBA_RECYCLEBIN

• http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN11681