RE: disable recyclebin?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 19 Apr 2011 10:47:08 -0400
Message-ID: <038e01cbfea0$a92ad490$fb807db0$_at_rsiz.com>

I like Toons' suggestion to do it by schema with a log on trigger. That should allow you to make use of it when indicated, especially with configurable off the shelf (COTS) application suites where you often cannot change the code or the ramifications of changing the code are unbounded. The capability is nice. The side effects of the change from not having a recycle bin to having a recycle bin are manifold and unpredictable in the general case. A lot more is involved in this consideration than just sticking a purge keyword on the end of a few drop statements.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen
Sent: Tuesday, April 19, 2011 10:17 AM
To: Oracle-L_at_freelists.org
Subject: RE: disable recyclebin?  

What's the push? People don't like to see all the BIN$ tables in a tool? I guess my argument would be to the user that they have the option of not using the recyclebin by using purge so why should I disable for the entire db. They have the option to turn it off/on as they seem fit which seems pretty good to me.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of 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:47:08 CDT