This guide contains reference information, with usage and syntax guidelines, for:

  • Oracle GoldenGate configuration parameters.

  • Oracle GoldenGate column-conversion functions.

  • Oracle GoldenGate user exit functions.

  • Oracle GoldenGate parameters, and functions for heterogeneous databases

For details on Admin Client and GGSCI commands, see Command Line Interface Reference for Oracle GoldenGate.


This guide is intended for persons who are responsible for installing and operating Oracle GoldenGate and maintaining its performance. This audience typically includes, but is not limited to, system administrators and database administrators.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Accessible Access to Oracle Support

Oracle customers who have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Related Information

The Oracle GoldenGate Product Documentation is available from the following location:

Oracle GoldenGate Documentation

Oracle GoldenGate for Big Data Documentation:

Oracle GoldenGate for Big Data

For OCI GoldenGate, refer to:

OCI GoldenGate

For details on Oracle Database High Availability, see:

Oracle Database High Availability


The following text conventions are used in this document:

Convention Meaning


Boldface type indicates graphical user interface elements associated with an action, such as "From the File menu, select Save." Boldface also is used for terms defined in text or in the glossary.



Italic type indicates placeholder variables for which you supply particular values, such as in the parameter statement: TABLE table_name. Italic type also is used for book titles and emphasis.



Monospace type indicates code components such as user exits and scripts; the names of files and database objects; URL paths; and input and output text that appears on the screen. Uppercase monospace type is generally used to represent the names of Oracle GoldenGate parameters, commands, and user-configurable functions, as well as SQL commands and keywords.


Uppercase in the regular text font indicates the name of a utility unless the name is intended to be a specific case.

{ }

Braces within syntax enclose a set of options that are separated by pipe symbols, one of which must be selected, for example: {option1 | option2 | option3}.

[ ]

Brackets within syntax indicate an optional element. For example in this syntax, the SAVE clause is optional: CLEANUP REPLICAT group_name [, SAVE count]. Multiple options within an optional element are separated by a pipe symbol, for example: [option1 | option2].