Re: disable recyclebin?

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Tue, 19 Apr 2011 15:58:49 +0200
Message-ID: <BANLkTimH=49QvMh_rfcbG36UsbGpP5ZupQ_at_mail.gmail.com>

Create login-triggers for the schemas that they want it to be disabled. And execute

Alter session set recyclebin=off;

from that trigger?

On Tue, Apr 19, 2011 at 3:55 PM, <TESTAJ3_at_nationwide.com> wrote:

>
> I'm getting push to disable the recyclebin on a 10.2.0.4 database?
>
> I'm pushing back that its not a good idea to disable it for the entire
> database but to disable for the session or do a drop table <table_name>
> purge instead.
>
> Your thoughts?
>
> thanks, joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
>
>

-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text

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

Received on Tue Apr 19 2011 - 08:58:49 CDT