Oracle's Recycle Bin

Each user has his/her own recycle bin.

The following command shows the contents of one's recycle bin:

select * from recyclebin;

Additionally, the recycle bin's content can also be displayed in SQL*PLUS with

SQL> show recyclebin

Use the purge SQL command to purge something in the recycle bin.

See _recyclebin and drop table purge.