How do I modify rules to ignore tagged LCRs?
edited Nov 29, 2011 4:30AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered ✓
I have discovered that using dbms_streams.set_tag has no effect and that the reason is (I think) that my rules (specifically capture rules)
do not include reference to "is_tag_null" condition. How do I fix it?
DB is 11.2.0.2, and all rules were created by using dbms_streams_adm.maintain_tables.
In discussions I see reference to using parameter "include_tagged_lcr" (in setup or "alter_rule") but I don't see any such parameter.
I also see reference to replacing rule_condition with text that has been altered to include:"and (:ddl.is_null_tag() = ”Y”)"
but this seems pretty drastic. I thought ignoring LCRs with tags set was default behavior.
0