Re: disable recyclebin?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Apr 2011 13:58:05 -0600
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...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
