Oracle GoldenGate Error Messages

OGG-00751

Failed to validate table {0}. Likely due to existence of unused columns. It will cause data integrity issue if you are not using sourcedefs in downstream Replicat or the target table doesn't have the same unused columns due to ASSUMETARGETDEFS or DDL replication. Please use 'DBOPTIONS ALLOWUNUSEDCOLUMN' parameter to override this.


Cause

The specified table contains unused columns. Oracle Supports tables with unused columns, but the support is disabled by default. Extract abends on these columns unless you use the DBOPTIONS parameter with the ALLOWUNUSEDCOLUMN option to force Extract to generate a warning and continue processing.


Action

Specify DBOPTIONS with ALLOWUNUSEDCOLUMN. When using this parameter, either the same unused column must exist in the target table, or a source definitions file must be created for Replicat with the DEFGEN utility. For more information about the source definitions file, see the Oracle GoldenGate administration documentation.