Below procedure on DB level on replication side can make trigger fires on below two table which is important for Golden Gate monitoring when we have disable trigger on DB side
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('GGS_ADMIN','GGS_HEARTBEAT','FALSE')
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('GGS_ADMIN','GGS_HEARTBEAT_HISTORY','FALSE')
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('GGS_ADMIN','GGS_HEARTBEAT','FALSE')
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('GGS_ADMIN','GGS_HEARTBEAT_HISTORY','FALSE')
Hi Dilip,
ReplyDeleteI am assuming GGS_ADMIN is the GGS_ADMIN is the owner name of the trigger and GGS_HEARTBEAT is the trigger , Is that correct ?
we have situation like when we are replicating the data from Golden gate what ever the trigger we have written is not working when we are running in the sql developer it is working fine ... i am hoping DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('GGS_ADMIN','GGS_HEARTBEAT_HISTORY','FALSE') will work for me .
Plase advice.
Regards,
Sri