oracle 11g: how to disabled triggers per session
From: <rgrzes1_at_gmail.com>
Date: Tue, 4 Feb 2014 07:03:02 -0800 (PST)
Message-ID: <e11faa1c-3f15-4156-b7b3-daa115a8f81f_at_googlegroups.com>
Hello,
Date: Tue, 4 Feb 2014 07:03:02 -0800 (PST)
Message-ID: <e11faa1c-3f15-4156-b7b3-daa115a8f81f_at_googlegroups.com>
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
Received on Tue Feb 04 2014 - 16:03:02 CET