RE: disable recyclebin?

From: Michael Rosenblum <mrosenblum_at_dulcian.com>
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?

Regards,
Michael Rosenblum
Dulcian Inc

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com [TESTAJ3_at_nationwide.com] Sent: Tuesday, April 19, 2011 9:55 AM
To: Oracle-L_at_FreeLists.org
Subject: disable recyclebin?

I'm getting push to disable the recyclebin on a 10.2.0.4 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

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

Received on Tue Apr 19 2011 - 09:05:01 CDT