CHAPTER 3Streams Rules and Rule Sets

The Oracle database has a built-in rules engine, and the Streams components—capture, propagation, and apply—are clients of the rules engine and use rules to perform their tasks in the replication process. The clients perform an action when a certain condition is satisfied or an event occurs that is defined in the rule.

In Oracle Streams, rules and rule sets determine whether or not a change or a message is to be captured, propagated, and applied. It is possible to have no rule set defined for the Streams clients. In the absence of a rule set, all changes to the database are captured, propagated, and applied. However, when you want to replicate only a portion of the database, rules must be defined to capture ...

Get Oracle Streams 11g Data Replication now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.