Showing posts with label GGS_Heartbit enable trigger on replicator when using DBOPTIONS SUPPRESSTRIGGER. Show all posts
Showing posts with label GGS_Heartbit enable trigger on replicator when using DBOPTIONS SUPPRESSTRIGGER. Show all posts

Saturday, 28 September 2013

GGS_Heartbit enable trigger on replicator when using DBOPTIONS SUPPRESSTRIGGER

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')