GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center