How to purge the Oracle Database Recycle Bin

In this Document
  
  
  

Applies to:

Oracle 10.1

Oracle 10.2

Oracle 11.1

Goal

How to purge the Oracle Database 10 / 11 recycle bin ?

Solution

Use the new statement called PURGE - examples:

Purge single objects out of recycle bin

PURGE {TABLE | INDEX };

Purge all objects in recycle bin out of one tablespace. With the option USER it is possible to delete all objects in recycle bin out of one tablespace belonging to the USER

PURGE TABLESPACE [USER ] ;

Purge all objects out of recycle bin belonging to the current USER

PURGE RECYCLEBIN;

Purge all objects out of recycle bin / only for SYSDBA

PURGE dba_recyclebin;