Re: disable recyclebin?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 21 Apr 2011 08:26:59 -0500
Message-ID: <BANLkTim4FZCaj3LFmdOXBzKvnfo5SKUa=Q_at_mail.gmail.com>

And then there are some DBAs I have run into who seem to think the drop table command is actually 'drop table <table name> purge;' The recyclebin is good not just for when you lose track of where you are working, but when you make a typo because the table names are too similar.

On Thu, Apr 21, 2011 at 2:36 AM, Holvoet, Jo <jo.holvoet_at_thomascook.be>wrote:

> "Some humans would do anything to see if it was possible to do it. If you
> put a large switch in some cave somewhere, with a sign on it saying
> 'End-of-the-World Switch. PLEASE DO NOT TOUCH', the paint wouldn't even have
> time to dry."
>
>
>
> — Terry Pratchett (Thief of Time)
>
>
>
> mvg / regards,
>
> Jo Holvoet
>
>
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mark W. Farnham
> *Sent:* woensdag 20 april 2011 19:00
> *To:* breitliw_at_centrexcc.com; 'oracle Freelists'
> *Cc:* TESTAJ3_at_nationwide.com; dbvision_at_iinet.net.au
> *Subject:* RE: disable recyclebin?
>
>
>
> 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.
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 21 2011 - 08:26:59 CDT