Is loop detection enabled by default in bi-directional Oracle-to-Oracle replication? And how to crea
edited May 20, 2015 10:00AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi GG Experts, I have to questions:
1 Is loop detection enabled by default in Oracle-to-Oracle bi-directional replication? I think it's not enabled by default, right?
Only in Teradata, it's enabled by default? In Oracle GG 11gR2 Admin Guide, page 98, it states that:
"
Preventing the capture of Replicat operations
Depending on which database you are using, you may or may not need to provide explicit instructions to prevent the capture of Replicat operations.
Preventing capture of Replicat transactions (Teradata)
To prevent the capture of SQL that is applied by Replicat to a Teradata database, set the Replicat session to override Teradata replication. Use the following SQLEXEC statements at the root level of the Replicat parameter file:
0