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

DDL support


GoldenGate allows DDL replication for Oracle databases, which is important when structural changes are made to your source tables. You would not want your Replicat process to abend because it can no longer insert a record into the respective target table. Prior to Oracle database Version 11.2.0.4, trigger based DDL has to be enabled to perform the DDL replication. Three setup scripts must be run in turn (as SYSDBA) on the source database to install the necessary software components: marker_setup.sql, ddl_setup.sql and role_setup.sql, which can be found in the GoldenGate Home directory. For later database versions, DDL replication is automatically supported without the need for manual installation.

GoldenGate will replicate the majority of ALTER TABLE commands including TRUNCATE. Commands that operate at the database level, such as ALTER DATABASE and ALTER SYSTEM, are not supported.

The following table lists all the supported DDL commands at the object level:

Operation

Object type...