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