Golden Gate - how to filter certain DMLs from replicating
848604May 18 2012 — edited May 24 2012Hi,
Is there a way to exclude certain DMLs from replicating to the target?
For eg. we have sqls like
delete from tab1 where rowid=:1;
&
delete /*+ ARCH */ from tab1 where rowid=:1;
insert into tab1 select * from tab2;
&
insert /*+ ARCH */ into tab1 select * from tab2;
We want only those DMLs without the word ARCH to get replicated. Is this possible via Golden Gate?
Oracle version is 11.2.0.4 & Golden Gate version is 10.4.0.19
Thanks in advance
-Tex