Oracle OGG-01163 兩端資料不一直導緻的問題處理

由于兩端資料不一緻導緻如下問題

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 [email protected]:/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.*;

---------