Re: oracle 11g: how to disabled triggers per session

From: Peter Schneider <>
Date: Wed, 05 Feb 2014 00:38:36 +0100
Message-ID: <lcrtot$ca9$>

Am 04.02.2014 17:33, schrieb joel garry:
> On Tuesday, February 4, 2014 7:03:02 AM UTC-8, wrote:
>> Hello,
>> Do You know any trick to disabled all triggers but only per session ?
>> I can't use dbms_xstream_gg.set_foo_trigger_session_contxt becouse I have Standard Edition.
>> I found the /*+ NO_TRIGGER */ hint method, but unfortunatelly it doesn't work.
>> I won't use method: add any extra line to the begining of all triggers, for example to check same context or samething like this... because it is a large database.
>> Regards
>> Robert
> What does the size of the database have to do with it? What does the trigger do that you want to disable it?

I guess he meant he didn't want to change hundreds or even thousands of trigger manually?


Climb the mountain not to plant your flag, but to embrace the challenge,
enjoy the air and behold the view. Climb it so you can see the world,
not so the world can see you.                    -- David McCullough Jr.
Received on Wed Feb 05 2014 - 00:38:36 CET

Original text of this message