Oracle GoldenGate Error Messages

OGG-00738

Object id [{0,number,0}], SCN [{1}], commit SCN [{2}] could not be resolved. Most likely this happens if DDL history for it was deleted. Please check purge parameters in manager parameter file (if it is too short). If that is ok, this was probably an object that was not filtered out and this can be ignored


Cause

Either this object ID represents something that Extract is not supposed to capture, or it is supposed to be captured but Oracle GoldenGate could not interpret the metadata, probably because the table was dropped after this record was generated.


Action

If this record is an object that must be captured, restore the GGS_DDL_HIST (DDL history) table from backup to restore the metadata for the specified object ID and SCN. To prevent future loss, set PURGEDDLHISTORY so that the retained history exceeds Extract lag.