Event Actions
It is important in any data replication environment to capture and manage events such as Trail records containing specific data or operations, or maybe the occurrence of a certain error. These are known as Event Markers.
GoldenGate provides a mechanism to perform an action on a given event or condition, these are known as Event Actions and are triggered by Event Records. If you are familiar with Oracle Streams, Event Actions are like Rules.
Event Records
An Event Record can be either a trail record that satisfies a condition evaluated by a WHERE
or FILTER
clause, or a record written to an event table enabling an action to occur. Typical actions are to write status information, report errors, ignore certain records in a trail, invoke a Shell script, or perform an administrative task.
The following Replicat example helps to describe the function of capturing an event and performing an action by logging DELETE
operations made against the CREDITCARD_ACCOUNTS_DIM
table using the EVENTACTIONS...