oracle purge recycle bin
-- Drop and recovery
DROP TABLE books;
FLASHBACK TABLE books TO BEFORE DROP;
DROP TABLE books PURGE; -- won't go in recycle bin
-- Contents of recycle bin
SELECT OWNER, ORIGINAL_NAME, OPERATION, TYPE, TS_NAME, DROPTIME, SPACE / 1e3
FROM DBA_RECYCLEBIN;
-- Purge
PURGE RECYCLEBIN;
PURGE DBA_RECYCLEBIN;
PURGE TABLE my_table;
-- Disable / enable recycle bin
ALTER SYSTEM SET DBA_RECYCLEBIN = off; -- on
ALTER SESSION SET DBA_RECYCLEBIN = off; -- on