Question : How can I empty the trash in Database
To remove the entire contents of your recycle bin, issue the following statement:
PURGE RECYCLEBIN ;To remove the entire contents of all recycle bin, issue the following statement
PURGE DBA_RECYCLEBIN ;