Monthly Archive: May 2015

SHOWSYNTAX : Oracle GoldenGate Tool To Debug A Replicat


Oracle GoldenGate has provided an excellent parameter to debug the Replicat process called SHOWSYNTAX. Obviously this should be used in the Target side (Replicat). This parameter is used to start an interactive session. That is, whenever an INSERT is replicated from Source to Target, before it is getting applied to the Target, the respective SQL statement will be displayed on screen. Upon using this parameter, you can view each and every Replicat SQL statement before it is applied.

Continue reading…