Is a Synchronous Capture Failing to Capture Changes to Tables?
If a synchronous capture is not capturing changes to tables as you expected, then the rules in the synchronous capture rule set might not be configured properly. To avoid problems, always use the ADD_TABLE_RULES or ADD_SUBSET_RULES procedure in the DBMS_STREAMS_ADM package to add rules to a synchronous capture rules set. The following are common reasons why a synchronous capture is not capturing changes as expected: • Global rules or schema rules are being used to try to control the behavior of the synchronous capture. A synchronous capture ignores global rules and schema rules in its rule set. A synchronous capture only captures changes that satisfy table rules and subset rules. • The the DBMS_RULE_ADM package was used to configure the rules for a synchronous capture. A synchronous capture does not behave correctly when • The DBMS_RULE_ADM package is used to create rules that are added to a synchronous capture rule set. • The DBMS_RULE_ADM package is used to add rules to a synchronous
