6.43 DDLTABLE

Valid For

GLOBALS

Description

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.

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.

This parameter is only valid for an Oracle database in which 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