DISABLE TRIGGERS ON UPDATES DELETES AND INSERTS

[treedstang]

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

[jgmagnus]

Do you mean you want a script to disable constraints?
Or to just disable the triggers? Or what?

- Magnus

[rcaballe]

You can't disable Triggers nor constraints by session, if that are you asking :)

[jmodic]

You must modify your triggers so that they are "session specific" by using DBMS_SESSION_INFO package. For example look at [url]http://www.dbasupport.com/forums/showthread.php?threadid=7570[/url]

HTH,