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