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. Before we can perform DDL replication, two setup scripts must be run in turn, as SYSDBA on the source database to install the necessary software components; setup.sql and then ddl_setup.sql both of which can be found in the GoldenGate Home directory.

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

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

Operation	Object type
CREATE	TABLE (includes AS SELECT)
ALTER	INDEX
DROP	TRIGGER
RENAME	SEQUENCE
COMMENT ON TABLE	MATERIALIZED VIEW
COMMENT ON COLUMN	VIEW
	FUNCTION
	PACKAGE
	PROCEDURE
	SYNONYM
Permission	Object type...