Re: disable recyclebin?
Date: Wed, 20 Apr 2011 13:58:05 -0600
Message-Id: <CB9382A3-FD90-4856-BDDD-39A82605DB27_at_centrexcc.com>
There is no such thing as a free lunch. As far as features are concerned there are always costs or side-effects. At the very least having those recyclebin objects around consumes space and time during backups. If I can avoid those costs by being careful when performing destructive actions and checking twice then I shall. Such actions should be scripted and how much effort does it take to put in a statement which checks for the database name and aborts if it is production. That should be a standard piece of code in every script and thus require a deliberate action to remove if you really mean production. Of course, as Mark pointed out, production can have many meanings and damaging a dev/test database by mistake can be just as costly as doing it in a "production" database.
On 2011-04-20, at 12:39 PM, Guillermo Alan Bort wrote:
> I had one experience where recycle bin saved me a lot of work, so I leave it on.
>
> I was working on a data refresh from a Prod DB to a Dev DB. I finished the consistent export from Prod and promptly dropped all the tables in the schema only to realize that I had dropped the tables in the PROD database.
>
> A restore would have taken several hours and customer was already pissed about delays in this implementation. After informing them of my mistake I restored all the tables from the recycle bin with a total downtime of 10 minutes (as opposed to several hours!). So... I leave Recycle Bin on.
>
> And I don't think that if you have a way to minimize impact people having to learn that there are consequences is a good argument against using that feature... it's like saying you don't buy stuff in the supermarket because people need to learn the real value of things or that you don't use computers because people need to learn to calculate stuff by themselves. Recycle Bin is there to make your life easier in the event of a MISTAKE, are you above making mistakes?
>
> I seem to be ranting a lot today... good thing i don't work tomorrow...
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 14:58:05 CDT