Deferred Primary Key causes data loss after replication with GoldenGate (Doc ID 2214399.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

create table s12 (a number not null, b number, c number);   --- source table
create table t12 (a number not null, b number, c number);   --- target table

alter table s12 add primary key (a) initially deferred;
alter table t12 add primary key (a) initially deferred;

insert into s12 (1,1,1);
commit;
insert into s12 (1,2,3);
delete from s12 where a=1 and b=1 and c=1;
commit;

after replication:

SQL> select * from s12;

A B C
---------- ---------- ----------
1 2 3

SQL> select * from t12;

no rows selected

 

 

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms