Oracle Database Blog‎ > ‎Info pages‎ > ‎

Recyclebin

Examples of PURGING
SQL> PURGE TABLE t1;
SQL> PURGE TABLE "BIN$1ScbgN8A1UtrTAgAIKds/b==$0";
SQL> PURGE INDEX ind1;
SQL> PURGE recyclebin;
SQL> PURGE dba_recyclebin; (SYSDBA only)
SQL> PURGE TABLESPACE users;
SQL> PURGE TABLESPACE users USER bh;

User can purge must be owner, SYSDBA or with DROP ANY system privilege.

DISABLING RECYCLEBIN
SQL> ALTER SYSTEM SET "_recyclebin"=FALSE SCOPE = BOTH;
SQL> ALTER SESSION SET recyclebin = OFF;
SQL> ALTER SYSTEM SET recyclebin = OFF;

SQL> SHOW recyclebin
SQL> DROP TABLE t1 PURGE;