Is supplemental logging at table level mandatory for goldengate
Hello Experts,
- I have recently migrated 19c database from solaris to Linux platform.In Solaris we had 19c goldengate with classic extract configured.In new Linux host we are maintaining same version (19c) of db and goldengate but changed to Integrated extract.We had below kind of table level suppmental logging for certain number of tables which I forgot to add but database level all columns logging is present.
add trandata CISADM.CI_BSEG, COLS (BSEG_ID), NOKEY
Kindly note that BSEG_ID is the primary key column.
Now my question is do we really need to add table level logging?
- I have recently migrated 19c database from solaris to Linux platform.In Solaris we had 19c goldengate with classic extract configured.In new Linux host we are maintaining same version (19c) of db and goldengate but changed to Integrated extract.We had below kind of table level suppmental logging for certain number of tables which I forgot to add but database level all columns logging is present.
add trandata CISADM.CI_BSEG, COLS (BSEG_ID), NOKEY
Kindly note that BSEG_ID is the primary key column.
Now my question is do we really need to add table level logging?
0