PURGE — clean recycle bin
PURGE RECYCLEBIN [ ALL ]
Use this commad to purge the current user's recycle bin. The database will remove all objects from the user's recycle bin and release all space associated with objects in the recycle bin.
ALLAllow superuser to purge all users' tables in recycle bin.
To clean current user's recycle bin:
PURGE RECYCLEBIN;