由于两端数据不一致导致如下问题
OGG-01163 Bad column length (8) specified for column EXCHANGERATE in table
-- 解决办法
-- 源端：
GGSCI (BJZX-SR2) 42> edit params defgen
-------
defsfile /u01/app/oracle/ogg11/test_pri.def
Userid ogguser, password ogguser
table zzh.TEST;
-------
$defgen paramfile ./dirprm/defgen.prm
-- 把文件传输到目标端
scp test_pri.def oracle@192.168.11.61:/u01/app/oracle/ogg11
-- 目标端
GGSCI (dbpay) 11> edit params R_PIONER
--------
REPLICAT r_pioner
--DBOPTIONS ALLOWUNUSEDCOLUMN
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID system, password SV8_ppsystem2014
HANDLECOLLISIONS
--ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/R_PIONER.DSC, append, megabytes 10
sourcedefs /u01/app/oracle/ogg11/test_pri.def
APPLYNOOPUPDATES
GETTRUNCATES
GETUPDATES
Dynamicresolution
DDL INCLUDE ALL
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDLERROR DEFAULT IGNORE RETRYOP
Tableexclude zzh.SYS_EXPORT_SCHEMA_*
Tableexclude zzh.SYS_EXPORT_TABLE_*
Tableexclude zzh.SYS_IMPORT*
MAP zzh.* , TARGET zzh.*;
---------
