We use to do exactly that (leave it enabled, but daily job to purges objects of
worth offender app schemas) at one of my client site. This way, we knew if
there was a bad application creating/dropping objects (like Sybase/SQL server
hash tables). We use to ask app team to modify their code/script to eliminate
this create/drop and replace it with CTE (Common Table Expression) or SubQuery
Factoring as its called in Oracle.
It helped us many times, when someone accidentally dropped tables in prod (I
know they should not be anywhere near prod, if they are so careless, but I
could only enforce so many rules.)
Regards,
Vishal Gupta
From: <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of Franck Pachot
<franck@xxxxxxxxxx>
Reply-To: <franck@xxxxxxxxxx>
Date: Friday, 20 January 2017 at 20:25
To: <neil_chandler@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>, "jckelly@xxxxxxxxx" <jckelly@xxxxxxxxx>
Subject: 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@xxxxxxxxxxx> 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@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