Re: disable recyclebin?
Date: Wed, 20 Apr 2011 15:39:01 -0300
Message-ID: <BANLkTi=-rdD4E8Zk+cPaiRQHJWAPeo9-Tw_at_mail.gmail.com>
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.-
On Wed, Apr 20, 2011 at 2:00 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> I tend to agree, with an exemption for things like student databases and
> other sorts of things being used by non-professionals. And of course those
> databases would be entirely separate from anything remotely smacking of
> production. (And the dev and test databases ARE production to developers and
> testers, with a higher waste cost per outage hour than many production
> databases.) Even for students you might want it off for some schemas though,
> so I still like Toons’ idea of triggers for that case.
>
>
>
> Cary mentioned a theory he has that if one of those windows confirmation
> chicklets popped up that read “Hit ok if you want to end the universe” that
> either nearly everyone or everyone would hit the doggone thing anyway.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Wolfgang Breitling
> *Sent:* Wednesday, April 20, 2011 12:17 PM
> *To:* oracle Freelists
> *Cc:* TESTAJ3_at_nationwide.com; dbvision_at_iinet.net.au
> *Subject:* Re: disable recyclebin?
>
>
>
> I'm with Nuno on this. We survived several releases of Oracle without a
> recyclebin ( btw, I also turn it off in Windows - if I have to use Windows
> ). While it may come in handy at occasions that doesn't make it a necessity.
> Everyone needs to learn that there are consequences to every action, so
> think twice before you do something destructive - and a drop is not the only
> destructive action possible.
>
>
>
> On 2011-04-20, at 3:11 AM, TESTAJ3_at_nationwide.com wrote:
>
>
>
>
> Nuno, don't you have concern about inadvertent drops of tables?
>
> joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
>
>
>
> From:
>
> Nuno Souto <dbvision_at_iinet.net.au>
>
> To:
>
> oracle-l_at_freelists.org
>
> Date:
>
> 04/20/2011 04:58 AM
>
> Subject:
>
> Re: disable recyclebin?
>
> Sent by:
>
> oracle-l-bounce_at_freelists.org
>
>
> ------------------------------
>
>
>
>
> And that's one of the reasons why recycle bin is disabled in all my dbs.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 13:39:01 CDT