Purge RECYCLEBIN in Oracle

Purge RECYCLEBIN in Oracle

by

In Oracle, the RECYCLEBIN feature by default is enabled. To protect eccidentally dropped tables. “purge recyclebin in oracle”. Oracle scripts.

SQL> col OBJECT_NAME for a32
SQL> col ORIGINAL_NAME for a10
SQL> set lin 300 pagesize 200

SQL> select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime  2  from recyclebin; OBJECT_NAME                    ORIGINAL_N TYPE                      UND PUR DROPTIME------------------------------ ---------- ------------------------- --- --- -------------------BIN$9xLI1i7fQUbgU0c4qMAKTg==$0 XC         TABLE                     YES YES 2023-03-17:09:23:59

Other commands to purge recyclebin in oracle

Here are the more commands to check RECYCLEBIN, Check recycle-bin from SYSDBA account

SQL> Select * from dba_recyclebin;

Check Current session RECYCLEBIN

SQL> Show recyclebin 
SQL> select * from user_recyclebin;

Purges recyclebin from current session

Using the below commands we can purge the recyclebin from current session and purge recyclebin with single table.

Purge single table from current user

SQL> PURGE TABLE xc;

Purge all objects from current user

SQL> PURGE RECYCLEBIN;

Purge SYSDBA recyclebin

Purge all objects from recyclebin for all users from SYSDBA account.

SQL> PURGE DBA_RECYCLEBIN;

Drop table with purge

Drop objects without moving in recyclebin.

DROP table xc purge;

I hope this script commands help you, write your feelings in comment box.

Leave a Comment