Good point Neil, you are correct. I've been using GG since before Oracle
acquired them, its an old habit.
j
On 1/20/17 3:00 PM, Neil Chandler wrote:
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of John Kelly <jckelly@xxxxxxxxx>
*Sent:* 20 January 2017 19:28
*To:* oracle-l@xxxxxxxxxxxxx
*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