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

W dniu wtorek, 4 lutego 2014 16:03:02 UTC+1 użytkownik rgr..._at_gmail.com napisał:
> 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

Hello,
In my case disable triggers is of course legal and conscious But of course I understand if in many cases it can be inlegal or can take same related problems -> it depends on special case :)

I realized it by automatic adding an extra first line on the begining of any triggers that checks same session parameter.

Thanks for help

Regards
Robert Received on Wed Feb 05 2014 - 11:46:12 CET