GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center