DDLTABLE

Valid For

Oracle, DB2 z/OS

Description

This is a GLOBALS parameter. Use the DDLTABLE parameter to specify the name of the DDL history table, if other than the default of GGS_DDL_HIST. The DDL history table stores a history of DDL operations processed by Oracle GoldenGate.

In DB2 z/OS an acceptable value is a valid DB2 z/OS table name.

For Oracle database only:

The name of the history table must also be specified with the ddl_hist_table parameter in the params.sql script. This script resides in the root Oracle GoldenGate installation directory.

The capture configuration uses the Oracle GoldenGate DDL trigger to support DDL replication. For more information about the Oracle GoldenGate DDL objects, see Installing Trigger-Based DDL Capture in Using Oracle GoldenGate for Oracle Database.

Default

GGS_DDL_HIST

Syntax

DDLTABLE table_name

table_name: The fully qualified name of the DDL history table. This can be a two-part name (schema.table) or a three-part name, if stored in a container database (container.schema.table).

Example

DDLTABLE GG_DDL_HISTORY