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;
/

25 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. Excellent Submit, Very Informative. I’m Wondering Why VT Markets Opposite Specialists Of This Sector Don’t Realize This. You Should Continue Your Writing. I’m Confident, You Have A Great Readers’ Base Already!

    ReplyDelete
  10. Good Way Of Telling, And Pleasant VT Markets Paragraph To Get Information About My Presentation Topic, Which I Am Going To Deliver In Academy.

    ReplyDelete
  11. 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