SQL> select OWNER,TRIGGER_NAME,STATUS from dba_triggers where TRIGGER_NAME='TR_MTRL_STOCK_THREE_CLOUDHIS'; OWNER TRIGGER_NAME STATUS ------------------------------ ------------------------------ -------- HRP_xxx TR_MTRL_STOCK_THREE_CLOUDHIS ENABLED SQL> SQL> alter trigger TR_MTRL_STOCK_THREE_CLOUDHIS disable; Trigger altered. SQL> SQL> select OWNER,TRIGGER_NAME,STATUS from dba_triggers where TRIGGER_NAME='TR_MTRL_STOCK_THREE_CLOUDHIS'; OWNER TRIGGER_NAME STATUS ------------------------------ ------------------------------ -------- HRP_xxx TR_MTRL_STOCK_THREE_CLOUDHIS DISABLED
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28916011/viewspace-2726970/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
归档oracle alert日志
请登录后发表评论
登录
全部评论
