GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate - update statement not working when primary keys are different

edited May 23, 2018 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

Hi,

I'm trying to set up replication in oracle between two tables, similar cols, but different primary key.

Insert and deletes are working, but update.

Here are detail

create table nil_test ( c1 number,c2 number,c3 varchar2(10));

create table nil_test_rep ( c1 number,c2 number,c3 varchar2(10));

alter table nil_test add primary key (c1);

alter table nil_test_rep add primary key (c2,c1);

alter table nil_test add supplemental log data (all) columns;

-- in gg

add trandata X5.nil_test cols(c1,c2,c3), NOKEY

extract E_GG1NIL

    userid ggs_user@GGTEST1,password ggs_user;

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