Overview

Method

1. Query recyclebin for a specific account

SQL> 
SET LINESIZE 200 
SET PAGESIZE 200 
COL OWNER FOR A20 
COL OBJECT_NAME FOR A35 
COL ORIGINAL_NAME FOR A35 
COL TS_NAME FOR A30

SELECT OWNER, OBJECT_NAME, ORIGINAL_NAME, TYPE, TS_NAME, CREATETIME, DROPTIME 
FROM DBA_RECYCLEBIN 
WHERE OWNER='<OWNER>' 
AND ROWNUM <= 100;

SQL> PURGE TABLE "<OWNER>"."<TABLE_NAME>";

3. Delete all recyclebin objects belonging to the connected account

SQL> PURGE RECYCLEBIN;

SQL> PURGE DBA_RECYCLEBIN;

Note

The recyclebin does not have a fixed allocated space, nor does it provide a minimum retention period that guarantees data recovery. Therefore, if space runs low, objects in the recyclebin may be automatically deleted.