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  ?

 

 

 

Thanks,

KN

Legend

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