-
Can someone tell me how I would go by updating data in a oracle database without firing triggers and without interfering with my users that will be updating information from the front end apps is there a script that has to be ran in order to make this happen?
Thanks
-
Do you mean you want a script to disable constraints?
Or to just disable the triggers? Or what?
- Magnus
-
You can't disable Triggers nor constraints by session, if that are you asking :)
-
You must modify your triggers so that they are "session specific" by using DBMS_SESSION_INFO package. For example look at http://www.dbasupport.com/forums/sho...?threadid=7570
HTH,