Constraint and Trigger
902923Jul 26 2012 — edited Jul 26 2012Hi Experts,
I'm working on to setup one way replication between two oracle databases the version of database is 11.2.0.3 and GoldenGate version is 11.2. after executed Db check list script we have found more Tables with Deferred constraints. the question is we found two parameters one is SUPPRESSTRIGGERS and another one is DEFERREFCONST
can you please guide, when we have to use DEFERREFCONST and SUPPRESSTRIGGERS parameters? whether we have to use both the parameters in replicat process or any one is enough. sorry little bit confusing to understand the usage of these two things? both the databse having same data definition /triggers/constraints/sequence ...etc...