RE: Purge RECYCLEBIN by *age*
Date: Wed, 19 Feb 2014 20:49:19 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD1187D5BE5_at_G5W2716.americas.hpqcorp.net>
Oracle supports purging individual tables by name from the recycle bin so if you queried for those tables >= your target date you should easily be able to generate the commands to purge the desired tables.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#ADMIN11682
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Wednesday, February 19, 2014 12:11 PM
To: Maris Elsins
Cc: Hemant-K.Chitale_at_sc.com; ORACLE-L
Subject: Re: Purge RECYCLEBIN by *age*
I too would be interested in this, I don't believe I have ever seen this happen.
On Wed, Feb 19, 2014 at 3:35 PM, Maris Elsins <elmaris_at_gmail.com<mailto:elmaris_at_gmail.com>> wrote: Hi,
> That allows me to have the datafiles to not autoextend to a very large value - in a development environment.
From the same document: "Oracle(r) Database Backup and Recovery Basics 10g Release 2 (10.2)" http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1019426 For AUTO EXTEND-able tablespaces, objects are purged from the recycle bin to reclaim space before datafiles are extended. Do you observe a different behavior in your environment? Which version/platform it is?
--- Maris Elsins _at_MarisElsins<https://twitter.com/MarisElsins> www.facebook.com/maris.elsins<https://www.facebook.com/maris.elsins> On Wed, Feb 19, 2014 at 3:53 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com<mailto:Hemant-K.Chitale_at_sc.com>> wrote: 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<mailto:niall.litchfield_at_gmail.com>] Sent: Tuesday, February 18, 2014 8:36 PM To: elmaris_at_gmail.com<mailto: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<mailto: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<https://www.facebook.com/maris.elsins> On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com<mailto: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. -- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 19 2014 - 21:49:19 CET