Submitted Questions

  • Aug 11 2006
    07:07 PM
    6167
    6

    How to disable multiple triggers of a table at at a time?
    • shavali

    Raghavendra

    • Nov 19th, 2006

    Alter table disable all trigger;

    Brijesh Mishra

    • Oct 9th, 2006

    SQL> Spool c:tempdisable_all_triggerSQL> Select 'ALTER TRIGGER '|| trigger_name ||' disable;' from user_triggers;SQL> spool offafter that open file disable_all_trigger.lst and remove header part and save file.SQL>@c:tempdisable_all_trigger.lst