How to purge the Oracle Database Recycle Bin

How to purge the Oracle Database 10 / 11 Recycle Bin [ID 572029.1]
		修改時間 21-OCT-2009     型別 HOWTO     狀態 PUBLISHED

In this Document
  
  
  

---

Applies to:

Oracle Agile Engineering Data Management - Version: 6.0.1 to 6.1.0
Information in this document applies to any platform.

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;