oracle的主键问题,GoldenGate MSSQL Oracle的主键问题导致的错误

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);