Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

disable trigger in another database

735308Aug 26 2010 — edited Aug 26 2010
Hello,
I have a situation where i need to disable a trigger in another database while a job is running .
I did not think there was a way other than issuing an AQ or dbms_alert etc and then run a job on the other db to disable.

Is there any other way?

Any input is greatly appreciated.

ALTER TRIGGER test_trig disable; ---- in another db...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2010
Added on Aug 26 2010
2 comments
1,425 views