RE: Purge RECYCLEBIN by *age*
Date: Wed, 19 Feb 2014 09:53:09 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB6016D278C_at_HKMGAXMB103A.zone1.scb.net>
No, I cannot guarantee that an object will be available from the recylcebin for a week. However, I can assure that no object will persist in the recyclebin for more than a week. That allows me to have the datafiles to not autoextend to a very large value - in a development environment.
Hemant K Chitale
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Tuesday, February 18, 2014 8:36 PM
To: elmaris_at_gmail.com
Cc: Chitale, Hemant K; ORACLE-L
Subject: Re: Purge RECYCLEBIN by *age*
Maris
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 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-lReceived on Wed Feb 19 2014 - 02:53:09 CET