RE: disable recyclebin?

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Thu, 21 Apr 2011 09:36:12 +0200
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF701EB7D74_at_SW-GNETCW-MBX02.tcads.thomascook.com>

"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: