Re: disable recyclebin?
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2011 15:58:49 +0200
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
Other related posts:
