I have configured GoldneGate and Extract, Data pump and Replicat everything is working fine. However Update is not happening. Below are my Extract, Data Pump and Replicat file.

Extract File:

extract ext3
userid ogguser, password ogguser
exttrail /u01/app/oracle/product/11.2.0.4/ggsrc/dirdat/lt
DDL INCLUDE MAPPED
table gg01.t2;

Data Pump File:

extract dpump1
userid ogguser, password ogguser
rmthost targetGG, mgrport 7810
rmttrail /u01/app/oracle/product/11.2.0.4/ggtrg/dirdat/rt
passthru
table gg01.t2;

Replicat File:

replicat rep3
assumetargetdefs
userid ogguser, password ogguser
map gg01.t2, target gg01.t2;

Let me know, what parameters need to be configured to get update working.

Error which i get:

2016-11-28 21:45:32  WARNING OGG-01004  Aborted grouped transaction on 'GG01.T2', Database error 1403 (OCI Error ORA-01403: no da
ta found, SQL <UPDATE "GG01"."T2" x SET x."NAME" = :a4,x."ADDRESS" = :a5,x."AGE" = :a6,x."GENDER" = :a7 WHERE x."NAME" is NULL AN
D x."ADDRESS" is NULL AND x."AGE" is NULL AND x."GENDER" = :b3 AND ROWNUM = 1>).

2016-11-28 21:45:32  WARNING OGG-01003  Repositioning to rba 7748 in seqno 5.

2016-11-28 21:45:32  WARNING OGG-01154  SQL error 1403 mapping GG01.T2 to GG01.T2 OCI Error ORA-01403: no data found, SQL <UPDATE
 "GG01"."T2" x SET x."NAME" = :a4,x."ADDRESS" = :a5,x."AGE" = :a6,x."GENDER" = :a7 WHERE x."NAME" is NULL AND x."ADDRESS" is NULL
 AND x."AGE" is NULL AND x."GENDER" = :b3 AND ROWNUM = 1>.

Thanks!

up vote 0 down vote accepted

Got the answer. Below command had to be executed before executing update.

add trandata gg01.*

Thanks!

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.