Deferred Primary Key causes data loss after replication with GoldenGate
(Doc ID 2214399.1)
Last updated on JUNE 05, 2019
Applies to:Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.
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);
insert into s12 (1,2,3);
delete from s12 where a=1 and b=1 and c=1;
SQL> select * from s12;
A B C
---------- ---------- ----------
1 2 3
SQL> select * from t12;
no rows selected
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document