X-Received: by 10.58.85.3 with SMTP id d3mr4786649vez.40.1391597172342; Wed, 05 Feb 2014 02:46:12 -0800 (PST) X-Received: by 10.140.105.181 with SMTP id c50mr12228qgf.12.1391597172322; Wed, 05 Feb 2014 02:46:12 -0800 (PST) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.188.199.168.MISMATCH!takemy.news.telefonica.de!telefonica.de!news.unit0.net!cyclone01.ams2.highwinds-media.com!voer-me.highwinds-media.com!peer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!k15no12597450qaq.0!news-out.google.com!y18ni3751qap.1!nntp.google.com!f11no12623526qae.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Wed, 5 Feb 2014 02:46:12 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=195.245.84.100; posting-account=IUeF4goAAAAmZ9JWqbQ_yttnXC0-YQep NNTP-Posting-Host: 195.245.84.100 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: oracle 11g: how to disabled triggers per session From: rgrzes1@gmail.com Injection-Date: Wed, 05 Feb 2014 10:46:12 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Received-Body-CRC: 420235541 X-Received-Bytes: 2299 Xref: news.cambrium.nl W dniu wtorek, 4 lutego 2014 16:03:02 UTC+1 u=C5=BCytkownik rgr...@gmail.co= m napisa=C5=82: > Hello, >=20 >=20 >=20 > Do You know any trick to disabled all triggers but only per session ? >=20 > I can't use dbms_xstream_gg.set_foo_trigger_session_contxt becouse I have= Standard Edition. >=20 > I found the /*+ NO_TRIGGER */ hint method, but unfortunatelly it doesn't = work. >=20 > I won't use method: add any extra line to the begining of all triggers, f= or example to check same context or samething like this... because it is a = large database. >=20 >=20 >=20 > Regards >=20 > 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 s= ame related problems -> it depends on special case :) I realized it by automatic adding an extra first line on the begining of an= y triggers that checks same session parameter. Thanks for help Regards Robert