RE: disable recyclebin?

From: Michael Rosenblum <>
Date: Tue, 19 Apr 2011 10:05:01 -0400
Message-ID: <2673A0170447634DA7F7ABCA51E89FA9010383E7BE58_at_MAIL2.dulcian.local>

In my environment I prefer to have recycle been as it is, but to use "drop ... purge" whenever needed. And I trained my developers NOT to use this option at all - so I can restore tables after their mistakes (and these cases indeed happened), while they cannot make it worse.

The real question is why would anybody complain about recycle been? Too many tables being created/dropped on the fly?

Michael Rosenblum
Dulcian Inc

From: [] On Behalf Of [] Sent: Tuesday, April 19, 2011 9:55 AM
Subject: disable recyclebin?

I'm getting push to disable the recyclebin on a database?

I'm pushing back that its not a good idea to disable it for the entire database but to disable for the session or do a drop table <table_name> purge instead.

Your thoughts?

thanks, joe

Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
Received on Tue Apr 19 2011 - 09:05:01 CDT

Original text of this message