oracle 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