RE: disable recyclebin?
- From: "Chitale, Hemant Krishnarao" <Hemant.Chitale@xxxxxx>
- To: <cicciuxdba@xxxxxxxxx>
- Date: Thu, 21 Apr 2011 11:27:33 +0800
> I had one experience where recycle bin saved me a lot of work, so I
leave it on.
You were "lucky". RECYCLEBIN has no "GUARANTEE"d retention.
Table/Index segments in a Recyclebin may be auto-purged if the
tablespace is running low on free space.
So a developer who thinks "I don't need to worry about DROPs, I can
always get my table back" may find, 6 hours after dropping a table, that
he *cannot* get his table back.
(Conversely, the Note# 6977045.8 and Bug# 6977045 mean that sometimes
the auto-purge isn't quick enough, resulting in ORA-1652's in the middle
of a production batch !).
Hemant K Chitale
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guillermo Alan Bort
Sent: Thursday, April 21, 2011 2:39 AM
To: mwf@xxxxxxxx
Cc: breitliw@xxxxxxxxxxxxx; oracle Freelists; TESTAJ3@xxxxxxxxxxxxxx;
dbvision@xxxxxxxxxxxx
Subject: Re: disable recyclebin?
I had one experience where recycle bin saved me a lot of work, so I
leave it on.
I was working on a data refresh from a Prod DB to a Dev DB. I finished
the consistent export from Prod and promptly dropped all the tables in
the schema only to realize that I had dropped the tables in the PROD
database.
A restore would have taken several hours and customer was already pissed
about delays in this implementation. After informing them of my mistake
I restored all the tables from the recycle bin with a total downtime of
10 minutes (as opposed to several hours!). So... I leave Recycle Bin on.
And I don't think that if you have a way to minimize impact people
having to learn that there are consequences is a good argument against
using that feature... it's like saying you don't buy stuff in the
supermarket because people need to learn the real value of things or
that you don't use computers because people need to learn to calculate
stuff by themselves. Recycle Bin is there to make your life easier in
the event of a MISTAKE, are you above making mistakes?
I seem to be ranting a lot today... good thing i don't work tomorrow...
Cheers
Alan.-
This email and any attachments are confidential and may also be privileged. If
you are not the addressee, do not disclose, copy, circulate or in any other way
use or rely on the information contained in this email or any attachments. If
received in error, notify the sender immediately and delete this email and any
attachments from your system. Emails cannot be guaranteed to be secure or
error free as the message and any attachments could be intercepted, corrupted,
lost, delayed, incomplete or amended. Standard Chartered PLC and its
subsidiaries do not accept liability for damage caused by this email or any
attachments and may monitor email traffic.
Standard Chartered PLC is incorporated in England with limited liability under
company number 966425 and has its registered office at 1 Aldermanbury Square,
London, EC2V 7SB.
Standard Chartered Bank ("SCB") is incorporated in England with limited
liability by Royal Charter 1853, under reference ZC18. The Principal Office of
SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the
United Kingdom, SCB is authorised and regulated by the Financial Services
Authority under FSA register number 114276.
If you are receiving this email from SCB outside the UK, please click
http://www.standardchartered.com/global/email_disclaimer.html to refer to the
information on other jurisdictions.
Other related posts:
