Replicating tables that have fields with the default value sysdate
Hi
We have two tables between which replication is configured GoldenGate 19c. On the source side, the table has a "mod_date" field with a default value Sysdate and this field have parameter NULL=n, null values are not allowed. On the target side, a similar table is created, but for the same field, the default Sysdate is not set and the have parameter NULL=y, null values allowed
When on the source side, row are updated, but the "mod_date" field data not provided, and since it has a value Sysdate as default for field, the current date is substituted. However, this current date is not transmitted to the target DB, but only those field values that actually had some value. And it turns out that the "mod_date" field on the source DB is updated, and on the target DB the old unchanged value.