Purge recyclebin in database - Oracle Database Script. SQL> SQL> SELECT count(*) FROM DBA_RECYCLEBIN ; COUNT(*) ---------- 2132 SQL> purge recyclebin; Recyclebin purged. SQL> select count(*) from DBA_RECYCLEBIN ; COUNT(*) ---------- 0
SQL> SQL> SELECT count(*) FROM DBA_RECYCLEBIN ; COUNT(*) ---------- 2132 SQL> purge recyclebin; Recyclebin purged. SQL> select count(*) from DBA_RECYCLEBIN ; COUNT(*) ---------- 0