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@xxxxxxxxxxxxx>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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mark W. Farnham > *Sent:* woensdag 20 april 2011 19:00 > *To:* breitliw@xxxxxxxxxxxxx; 'oracle Freelists' > *Cc:* TESTAJ3@xxxxxxxxxxxxxx; dbvision@xxxxxxxxxxxx > *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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Wolfgang Breitling > *Sent:* Wednesday, April 20, 2011 12:17 PM > *To:* oracle Freelists > *Cc:* TESTAJ3@xxxxxxxxxxxxxx; dbvision@xxxxxxxxxxxx > *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@xxxxxxxxxxxxxx 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@xxxxxxxxxxxx> > > To: > > oracle-l@xxxxxxxxxxxxx > > Date: > > 04/20/2011 04:58 AM > > Subject: > > Re: disable recyclebin? > > Sent by: > > oracle-l-bounce@xxxxxxxxxxxxx > > > ------------------------------ > > > > > 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.'