Re: Purge RECYCLEBIN by *age*

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 <https://twitter.com/MarisElsins>
www.facebook.com/maris.elsins




On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com


> 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 https://www.sc.com/en/incorporation-details.html

> .

>


--
http://www.freelists.org/webpage/oracle-l