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

W dniu wtorek, 4 lutego 2014 17:10:43 UTC+1 użytkownik Mladen Gogala napisał:
> On Tue, 04 Feb 2014 07:03:02 -0800, rgrzes1 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
>
>
>
> There is no such magic. Why would you want to disable triggers in the
>
> first place? Triggers are used to enforce business rules. What rules
>
> would you want to bypass? Is it legal?
>
>
>
>
>
>
>
> --
>
> Mladen Gogala
>
> The Oracle Whisperer
>
> http://mgogala.byethost5.com

why magic ? why there is no ? there is -> dbms_xstream_gg.set_foo_trigger_session_contxt but not in Standard Edition I would like to disable because in specyfic sytuations before delete a part of related data from database I generate script which can back this operation after commit (for example in case of user mistake) and in this case the triggers can disturb same data...

'Triggers are used to enforce business rules' - not only... are you writing about audit ? 'Is it legal?' - why not ? what is inlegal in disable trigger ????????

Regards Received on Tue Feb 04 2014 - 22:48:39 CET