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
Example
DDLTABLE GG_DDL_HISTORY