I will explain Purge RecycleBin in Oracle in this post.
You can read the Recycle Bin post from the following link if you want to learn more detail about Recycle Bin .
You can purge recycle bin as follows. purge recyclebin will remove all objects from the user’s recycle bin and release all space associated with objects in the recycle bin
SQL> purge recyclebin; Recyclebin purged.
Purge dba_recyclebin needs sysdba privilige and it removes all objects from the system-wide recycle bin, and is equivalent to purging the recycle bin of every user
SQL> purge dba_recyclebin; DBA Recyclebin purged. SQL>
Purge Tablespace RECYCLEBIN
purge tablespace option purges all the objects residing in the specified tablespace from the recycle bin.
SQL> purge tablespace Users; Tablespace purged. SQL>
Purge Table RECYCLEBIN
You can purge any table as follows.
SQL> PURGE TABLE MSDEVECI.TEST; Table purged.
You can purge any dropped table as follows.
SQL> purge table "BIN$cxP2b6/dEnrgVQBAAAAADQ==$1"; Table purged.
You can check if the recycle bin is on or off as follows.
SQL> show parameter recyclebin; NAME TYPE VALUE ------------------------------------ ----------- recyclebin string on
Turn Off Recycle Bin
To disable the recycle bin, you can disable the recycle bin both for session and system level as follows.
ALTER SESSION SET recyclebin = OFF; ALTER SYSTEM SET recyclebin = OFF;
You can enable the recycle bin both for session and system level as follows.
ALTER SESSION SET recyclebin = ON; ALTER SYSTEM SET recyclebin = ON;
Do you want to learn Oracle Database for Beginners, then read the following articles.
12,443 views last month, 2 views today