Hi,
I have table scott.emp1 in source DB but not in Target DB
unfortunately REPLICAT process has been abended.
>> On Souce DB
SCOTT>select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
EMP1 TABLE
SALGRADE TABLE
>> On Target DB
SCOTT>select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE
GGSCI (AUSUAT) 32> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:01:03 00:11:20
tail -f ggserr.log
/home/oracle/goldengate/dirtmp.
2017-04-25 16:07:46 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2017-04-25 16:07:52 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table 'EMP1'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2017-04-25 16:07:52 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, rep1.prm: NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2017-04-25 16:07:52 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'SCOTT.EMP1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "SCOTT"."EMP1" SET "EMPNO" = :a8,"ENAME" = :a9,"JOB" = :a10,"MGR" = :a11,"HIREDATE" = :a12,"SAL" = :a13,"COMM" = :a14,"DEPTNO" = :a15 WHERE "EMPNO" = :b0 AND "ENAME" = :b1 AND "JOB" = :b2 AND "MGR" = :b3 AND "HIREDATE" = :b4 AND "SAL" = :b5 AND "COMM" is NULL AND "DEPTNO" = :b7 AND ROWNUM = 1>).
I have created emp1 table in target, but still replict process is abended !
but how can move forward ?
GGSCI (AUSUAT) 33> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (AUSUAT) 34> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:30:44 00:00:04