Re: Recyclebin usage

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