oracle触发器锁表,禁止oracle表的触发器trigger

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