Hi Expetrs,
Update statements throwing below error:
2012-11-07 10:40:11 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table AAAA. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-11-07 10:40:12 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table AAAA. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-11-07 10:40:15 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table BBBB. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-11-07 10:40:15 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table BBBB. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-11-07 10:40:16 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'abc.BBBB', Database error 100 (retrieving bind info for query).
2012-11-07 10:40:16 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 17466 in seqno 1384.
2012-11-07 10:40:16 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep1.prm: SQL error 1403 mapping abc.BBBB to abc.BBBB.
2012-11-07 10:40:16 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 20104 in seqno 1384.
2012-11-07 10:40:16 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rep1.prm: Error mapping from abc.BBBB to abc.BBBB.
2012-11-07 10:40:16 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
If I use KEYCOLS:
--extract file:
TABLE abc.INDIA , KEYCOLS (ID);
--replicat parameter file
MAP abc.INDIA, TARGET abc.INDIA , KEYCOLS (ID);
Encountered below error
2012-11-09 00:37:54 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: No unique key is defined for table INDIA. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-11-09 00:48:34 ERROR OGG-01168 Oracle GoldenGate Delivery for Oracle, rep1.prm: Encountered an update for target table abc.INDIA, which has no unique key defined. KEYCOLS can be used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target database. Use APPLYNOOPUPDATES to force the update to be applied using all columns in both the SET and WHERE clause.
2012-11-09 00:48:34 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
any clues plz ??
Regards,
Edited by: user13403707 on 19 Nov, 2012 10:55 PM