Re: Purge RECYCLEBIN by *age*

  • From: Maris Elsins <elmaris@xxxxxxxxx>
  • To: Hemant-K.Chitale@xxxxxx
  • Date: Tue, 18 Feb 2014 11:28:30 +0200

Hi,

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
@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@xxxxxx
> 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
> .
>

Other related posts: