Describes how to view the SQL statement a replicat is executing, showsyntax, nodynsql, nobinarychars (Doc ID 1138329.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 4.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Apr-2013***

Goal

It is possible to capture for examination the SQL statement that a replicat is about to execute.

This is useful for verifying the format of the statement and testing the statement through another client interface.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms