|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.