GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GG 21.7 Replicat abend when table has "default on null" using a sequence

GG Microservices 21.7, Oracle db 19.16 on OEL 7.9.

Created a table with a number column autopopulated on null from a sequence. Can insert ok most of the time, but deletes abend the replicat every other time, and the updates always seem to abend.

Goal of autopopulate is to avoid source code changes. I don't see any documentation restricting this usage. Sequence is not replicated so is created manually on target, but in theory it should not be invoked on the target anyway because the replicat applies logical change records.

Use case:

create table gg_tbl_ui2 (cola number, colb number, colc number, gg_pkui number default on null gg_pkui_seq_mds.nextval);

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