DBOPTIONS SUPPRESSTRIGGERS for delete cascade constraint on the target side (REPLICAT) in 11.1.0.7 is missing.

Ct was using OGG ver 10.4 initially for replicating from 9.2.0.8 on Sun Solaris to 11.1.0.7 on AIX.Ct ran into issues as they had 232 tables with 250 DELETE CASCADE constraints while replicating delete records.We gave the recommendation of disabling the constraint which obviously worked but the ct does not want to disable the constraint and involves lot of manual work. In working thru’ the issues with GG support, it was mentioned that OGG ver 11.1. would have a parameterthat was to be set in the REPLICAT which would fix this issue. In reading thru’ the Release noteshttp://download.oracle.com/docs/cd/E18101_01/doc.1111/e18165.pdf(Page 6).

the parameter SUPPRESSTRIGGERS is not available for 11gR1, 11.1.0.7.

I was adivsed to open an SR with GG support to check if there will be an additional buildon top of 11.1.1 so that this parameter becomes available for 11gR1. Otherwise the ct will not bevery happy as initially, we were told the ct that the parameter will be available for 11.1.0.7, but it didnt make it as per the doc. If we can build the same for 11.1.0.7 it will go a long way in maintaining this high profile ct.

check the OGG v11 guides and ensure that you are looking for SUPPRESSTRIGGERS or DEFERREFCONST.

SUPPRESSTRIGGERS********************Valid for Replicat for Oracle. Prevents triggers from firing on target objects that are configured for replication with Oracle GoldenGate. You can use this parameter for Oracle 10.2.0.5 and later patches, and for Oracle 11.2.0.2 and later, instead of manually disabling the triggers.

DEFERREFCONST****************Valid for Replicat for Oracle. Delays referential integrity constraint checking and enforcement by the database until the Replicat transaction is committed. You can use this parameter instead of disabling the constraints on the target tables if the database is Oracle version 9.2.0.7 and later.

When coming to SUPPRESSTRIGGERS, we have some packages added to 10.2.0.5 or 11.2.0.2 and above. Those packages are needed for this to work.

For 10.2.0.5, we need to use dbms_streams_auth.grant_admin_privilege and For 11.2.0.2, we use dbms_goldengate_auth.grant_admin_privilege.