Goldengate: REPLICAT ABENDS OGG-00423 Could not find definition for demo.xxxx

REPLICAT ABENDS OGG-00423 Could not find definition for demo.xxxx

This is a case-sensitivity issue. The object name in defgen file is treated as case-insensitive name and could not find the table definition.

Remove the asterisk key from the REPLICAT parameter file, eg:

MAP demo.*,  TARGET demo.*,

Instead of asterisk key and define the table name from the REPLICAT parameter file.

MAP demo.table1,  TARGET demo.table1,

  • August 20, 2018 | 40 views
  • Comments