RE: Purge RECYCLEBIN by *age*
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Feb 2014 20:49:19 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: Wednesday, February 19, 2014 12:11 PM
To: Maris Elsins
Cc: Hemant-K.Chitale@xxxxxx; 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@xxxxxxxxx<mailto:elmaris@xxxxxxxxx>> 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
@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@xxxxxx<mailto: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<mailto:niall.litchfield@xxxxxxxxx>]
Sent: Tuesday, February 18, 2014 8:36 PM
To: elmaris@xxxxxxxxx<mailto: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<mailto: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<https://www.facebook.com/maris.elsins>
On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K
<Hemant-K.Chitale@xxxxxx<mailto: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.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
