Re: Purge RECYCLEBIN by *age*
- From: Maris Elsins <elmaris@xxxxxxxxx>
- To: Hemant-K.Chitale@xxxxxx
- Date: Wed, 19 Feb 2014 17:35:02 +0200
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
@MarisElsins <https://twitter.com/MarisElsins>
www.facebook.com/maris.elsins
On Wed, Feb 19, 2014 at 3:53 AM, Chitale, Hemant K
<Hemant-K.Chitale@xxxxxx>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@xxxxxxxxx]
> *Sent:* Tuesday, February 18, 2014 8:36 PM
> *To:* elmaris@xxxxxxxxx
> *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@xxxxxxxxx> 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
>
> @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
> .
>
>
>
>
>
>
>
> --
> 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
> .
>
Other related posts:
