Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

The DDL support


GoldenGate supports the replication of DDL commands operating at the schema level. By default, the DDL replication is enabled on the target (Replicat) for data integrity and disabled on the source (Extract). If you wish to perform DDL and DML replication from your source database, the DDL part must be explicitly configured through a single DDL parameter statement.

The support for DDL has increased since the integrated capture feature was introduced in Oracle 11g Release 2. If you wish to perform extensive DDL replication, particularly in the active-active configuration, refer to the following online Oracle documentation to assess the data type and database object support:

https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/system_requirements.htm#GIORA121

The DDL replication for database tables is supported in Teradata database environments for unidirectional and bidirectional configurations between two systems. The source and target database must be identical.

The DDL replication...