Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate - how to filter certain DMLs from replicating

848604May 18 2012 — edited May 24 2012
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2012
Added on May 18 2012
7 comments
331 views