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 .
What is the Recycle bin and How to Restore Dropped Tables from 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.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
13,519 views last month, 1 views today