Re: Recyclebin usage

I keep it enabled and have a purge process that purges the recyclebin once a week. I personally keep it enabled because my company loves giving production database access to crazy DBAs. I have used the recyclebin to save the day couple times. My manager is the most optimistic person I know in my life and he thinks all DBAs should have access to production... junior DBAs and newly hired DBAs... :(

On Fri, Jan 20, 2017 at 4:35 PM, Hustler DBA <hustlerdba_at_gmail.com> wrote:

> I keep it enabled and have a purge process that purges the recyclebin once
> a week. I personally keep it enabled because my company loves giving
> production database access to crazy DBAs. I have used the recyclebin to
> save the day couple times. My manager is the most optimistic person I know
> in my life and he thinks all DBAs should have access to production...
> junior DBAs and newly hired DBAs... :(
>
>
>
> On Fri, Jan 20, 2017 at 3:25 PM, Franck Pachot <franck_at_pachot.net> wrote:
>
>> Hi,
>> There is a middle position between disable or enable: enable it and have
>> a morning job that purges recyclebin every day. Mistakes of the day will be
>> covered but storage has a limit.
>> Regards,
>> Franck
>>
>> Le ven. 20 janv. 2017 à 21:01, Neil Chandler <neil_chandler_at_hotmail.com>
>> a écrit :
>>
>>> John,
>>>
>>>
>>> You only need to disable the recyclebin for Goldengate in Oracle 10G if
>>> using DDL replication. From Oracle 11G onwards it's safe to leave it on.
>>>
>>>
>>> regards
>>>
>>>
>>> Neil Chandler.
>>>
>>>
>>> ------------------------------
>>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
>>> on behalf of John Kelly <jckelly_at_aidhm.com>
>>> *Sent:* 20 January 2017 19:28
>>> *To:* oracle-l_at_freelists.org
>>> *Subject:* Re: Recyclebin usage
>>>
>>> I usually disable the recyclebin, it has always been more annoying than
>>> useful. And if you are using Goldengate, the documentation explicitly
>>> requires the recyclebin be disabled.
>>>
>>> cheers,
>>>
>>> j
>>> On 1/20/17 8:19 AM, Beckstrom Jeffrey wrote:
>>>
>>> Do you use the recycle bin yes or no and why? We are considering
>>> disabling it and are interested in the communities thoughts before doing so.
>>>
>>> Jeffrey Beckstrom
>>> Lead Database Administrator
>>> Information Technology Department
>>> Greater Cleveland Regional Transit Authority
>>> 1240 W. 6th Street
>>> Cleveland, Ohio 44113
>>>
>>>
>>>
>

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