Re: Purge RECYCLEBIN by *age*

I don't believe that to be *always* true, even in the form which I suspect you meant (they will be purged automatically starting with the oldest ones in the tablespace in which you require free space), AFAIK the blocks involved are free to be reused as and when a space allocation occurs, I don't believe there is any mechanism which prioritizes the extent allocation by age.

Hemant

What are you hoping to achieve with this? A guarantee that an object can be recovered for a week after it is dropped?

On Tue, Feb 18, 2014 at 9:28 AM, Maris Elsins <elmaris_at_gmail.com> wrote:

> 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
> _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.
>>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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