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

On Tuesday, February 4, 2014 7:03:02 AM UTC-8, rgr..._at_gmail.com 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?

jg

-- 
_at_home.com is bogus.
http://www.forbes.com/sites/oracle/2014/02/03/oracles-larry-ellison-how-to-manage-your-most-precious-assets/