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!

suppresstriggers not working in Goldengate

1045340May 6 2016 — edited May 9 2016

I have unidirectional replication configured using Goldengate where the "suppresstriggers" option doesnot seems to be working.

Environment on Source & Target servers:

=============================

Oracle Database version : 11.2.0.4.0 Enterprise Edition.

Goldengate version : 11.2.1.0.1

OS: Red-hat Linux

---Below is Replicat parameter file where I have defined suppresstriggers option.

===================================================

replicat rep1

ASSUMETARGETDEFS

userid ggs_admin, password qwerty

dboptions suppresstriggers;

handlecollisions

discardfile /home/goldengate/discard.txt, append, megabytes 10

ddl include all

DDLERROR DEFAULT IGNORE RETRYOP;

--Specify table mapping ---

map sender.*, target receiver.*;

===================================================

I have also executed "dbms_goldengate_auth.grant_admin_privilege('ggs_admin') on target database.

Created following trigger on source database , the tables used in below trigger are present on target database as well.

create or replace trigger t3_trig

after update of id3 on t3

for each row

begin

insert into t5 values(:new.id3);

end;

/

The trigger is still getting fired on target database even with the above option set on replicat

Please suggest.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2016
Added on May 6 2016
3 comments
1,137 views