GETNEWCOLUMNS | IGNORENEWCOLUMNS

Valid for

Extract, Replicat

Description

Use GETNEWCOLUMNS to retrieve records from the TMF audit trails that describe new SQL column changes. GETNEWCOLUMNS enables two different activities:

• Updates table definitions in Extract and downstream in Replicat, without bringing either process down first (NonStop replication only). This lets you replicate columns added to a table after Oracle GoldenGate startup.

• Downstream in Replicat (NonStop only), replicates the statement that created the column.

Apply GETNEWCOLUMNS to files or Oracle GoldenGate trails individually. This means that you can withhold new column records from specific Extract files. To ensure that the column exists in the target database before replicating into it, it is recommended that GETNEWCOLUMNS apply to all files in the Oracle GoldenGate trail.

Default

GETNEWCOLUMNS

Syntax

GETNEWCOLUMNS | IGNORENEWCOLUMNS