Re: Purge RECYCLEBIN by *age*

From: Maris Elsins <>
Date: Tue, 18 Feb 2014 11:28:30 +0200
Message-ID: <>


Why would you want to purge them?
They will be purged automatically started with the oldest ones when free space is needed.

To answer the question, I think it's not possible unless you write a script that queries the objects that you want to be purged from dba_recyclebin and then purging them one by one.

Maris Elsins
_at_MarisElsins <>

On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K <

> wrote:

> Is it possible to Purge the RECYCLEBIN by age ? --- e.g. remove those
> objects that were DROPped 7 days ago. That way, a periodic cleanup of the
> RECYCLEBIN can be done and yet objects may be available for recovery for 7
> days.
> Hemant K Chitale
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at
> .
Received on Tue Feb 18 2014 - 10:28:30 CET

Original text of this message