RE: disable recyclebin?
- From: Michael Rosenblum <mrosenblum@xxxxxxxxxxx>
- To: "TESTAJ3@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2011 10:05:01 -0400
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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of TESTAJ3@xxxxxxxxxxxxxx [TESTAJ3@xxxxxxxxxxxxxx]
Sent: Tuesday, April 19, 2011 9:55 AM
To: Oracle-L@xxxxxxxxxxxxx
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
Other related posts:
