This discussion is archived
1 Reply Latest reply: Oct 19, 2013 3:23 AM by Srini Chavali-Oracle RSS

disable trigger

979524 Newbie
Currently Being Moderated

Hi All,


   I have one trigger xxxxx in database version 11gR2 and I used the command to disable the same " alter trigger xxxxx disable"


  But when I qerey , still showing status valid when querey against dba_objects.


  1 - How I can verify the trigger xxxxx is disabled properly  ?







  • Correct Answers - 10 points
  • Helpful Answers - 5 points