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;