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.