Thank you Roy...that hit the spot perfectly.
Message from "Pardee, Roy" <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received on 09/12/2006 03:08 PM 09/12/2006 03:08 PM "Pardee, Roy" <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM Please respond to "Discussion of advanced .NET topics." <[email protected]> Sent by "Discussion of advanced .NET topics." <[email protected]> To: [email protected] cc: Subject: Re: [ADVANCED-DOTNET] Enabling all triggers in DB on Oracle Oooh--fun arms race. ;-) The thing I remember fondly about oracle is how complete & accessible its data dictionary is--I bet you there's a dba_triggers view or some such that you could use to identify any triggers that are disabled. Sure enough: http://www.ss64.com/orad/DBA_TRIGGERS.html -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Franklin Gray Sent: Tuesday, September 12, 2006 12:59 PM To: [email protected] Subject: [ADVANCED-DOTNET] Enabling all triggers in DB on Oracle I would like to enable all triggers in our DB that runs on a oracle client machine from VB.net. Anybody know how to do this without knowing which triggers are already there? We could run SQL scripts to enable them but then when we add new triggers I have a feeling they would be forgotten in this utility and then the finger pointing would start. I want to enumerate through the existing triggers and enable them if they aren't enabled. Our client has a habbit of disabling our triggers. =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
