Wednesday, February 17, 2010

DISABLE & ENABLE all the triggers in the schema

DISABLE & ENABLE all the triggers in the schema

BEGIN
FOR i IN (SELECT trigger_name
FROM user_triggers) LOOP

EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE';

EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' ENABLE';

END LOOP;
END;
/

23 comments:

  1. Thanks Man..
    Very Simple Yet much effective piece of information..

    ReplyDelete
  2. did the job perfectly for me, thx a lot.

    ReplyDelete
  3. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way. Thank you so much.
    Web Designing Course in chennai
    PHP Training in Chennai
    web designing training
    web designing in chennai
    PHP courses in chennai
    PHP Training Chennai

    ReplyDelete
  4. Your blog is so inspiring for the young generations.thanks for sharing your information with us and please update more new ideas.
    AWS Certification Training in T nagar
    AWS Training in Chennai Anna Nagar
    AWS Certification Training in Bangalore
    AWS Certification Training

    ReplyDelete
  5. Your article is amazing.just love it. you might be interested in :bike race apk

    ReplyDelete
  6. Thanks for this article.You might be interested in :head ball 2

    ReplyDelete
  7. Appreciating the persistence you put into your blog and detailed information you provide.

    blue prism Course Training in Chennai |Best blue prism Training Institute in Chennai

    ReplyDelete
  8. Think This Is Owsm Post, But If You Check This GATE IO

    ReplyDelete
  9. I believe there are many more pleasurable opportunities ahead for
    individuals that looked at your site.
    Hadoop admin training in Chennai
    software testing institute in Chennai
    javascript course in Chennai

    ReplyDelete