Ativar TRIGGER PROCEDURE Oracle

SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS;

SELECT OBJECT_NAME, status from user_objects WHERE OBJECT_TYPE='PROCEDURE';

SELECT object_name, object_type from obj WHERE STATUS !='VALID';

Ativa a PROCEDURE

ALTER PROCEDURE HR_FOLPRF compile;
ALTER PROCEDURE HR_HORPRF compile;
ALTER PROCEDURE HR_INCHOR compile;
ALTER PROCEDURE HR_LERAPU compile;
ALTER PROCEDURE HR_SUBREFCOL compile;
ALTER PROCEDURE HR_VALREFCOL compile;
ALTER PROCEDURE PP_HorFun compile;
ALTER PROCEDURE PP_HorLoc compile;
ALTER PROCEDURE RH_CHECKVALCOP compile;
ALTER PROCEDURE RH_HORSRV compile;
ALTER PROCEDURE RH_RETESC compile;
ALTER PROCEDURE RH_RETHOR compile;
ALTER PROCEDURE SP_REPFUN compile;

Verifica o STATUS da PROCEDURE

select status from user_objects where object_name = 'HR_FOLPRF';
select status from user_objects where object_name = 'HR_HORPRF';
select status from user_objects where object_name = 'HR_INCHOR';
select status from user_objects where object_name = 'HR_LERAPU';
select status from user_objects where object_name = 'HR_SUBREFCOL';
select status from user_objects where object_name = 'HR_VALREFCOL';
select status from user_objects where object_name = 'PP_HorFun';
select status from user_objects where object_name = 'PP_HorLoc';
select status from user_objects where object_name = 'RH_CHECKVALCOP';
select status from user_objects where object_name = 'RH_HORSRV';
select status from user_objects where object_name = 'RH_RETESC';
select status from user_objects where object_name = 'RH_RETHOR';
select status from user_objects where object_name = 'SP_REPFUN';

Ativa TRIGGER

ALTER TRIGGER trigger_name ENABLE;\ ALTER TABLE table_name ENABLE ALL TRIGGERS;

Desativar TRIGGER

ALTER TRIGGER trigger_name DISABLE;\

Verifica o STATUS da TRIGGER

SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'NOME_TRIGGER';

SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME IN ('NOME_TRIGGER1', 'NOME_TRIGGER2', 'NOME_TRIGGER3');

https://www.techonthenet.com/oracle/triggers/enable.php https://www.techonthenet.com/oracle/triggers/enable_all.php

https://www.techonthenet.com/oracle/triggers/disable.php https://www.techonthenet.com/oracle/triggers/disable_all.php

https://www.mkyong.com/oracle/oracle-plsql-enable-and-disable-triggers