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