2013-07-16 11:14:01 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, MSREP.prm: No unique key is defined for table 'EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2013-07-16 11:14:01 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, MSREP.prm: NLS_LANG character set US7ASCII on the target is different from the source database character set ZHS16GBK. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2013-07-16 11:14:01 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Command received from GGSCI: STATS.
2013-07-16 11:18:31 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Command received from GGSCI: STATS.
2013-07-16 11:18:31 WARNING OGG-01431 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Aborted grouped transaction on 'GGS.EMP', Mapping error.
2013-07-16 11:18:31 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Repositioning to rba 1044 in seqno 0.
2013-07-16 11:18:31 WARNING OGG-01151 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Error mapping from dbo.emp to GGS.EMP.
2013-07-16 11:18:31 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Repositioning to rba 1044 in seqno 0.
2013-07-16 11:18:31 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, MSREP.prm: Error mapping from dbo.emp to GGS.EMP.
2013-07-16 11:18:31 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, MSREP.prm: PROCESS ABENDING.
采取的解决方式也很简单,因MSSQL的emp表已经有了主键,所以在oracle数据库里定义好主键就解决了问题
也可以采用KEYCOLS参数定义target的主键
REPLICAT MSREP
USERID ggs@orcl, PASSWORD ggs
SOURCEDEFS dirdef/emp.def
MAP dbo.emp, TARGET ggs.emp,keycols(id);