1.47 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.

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