OGG colmap 参数实验:
源,目标端简历表
OG1:create table colmap(id1 number,id2 number,id3 number);
OG2:create table colmap(id1 number,id2 number,id3 varchar2(2));
注意两个id3 数据类型不同
源端:
GGSCI (OGG1) 26> add trandata gg.colmap
Logging of supplemental redo data enabled for table GG.COLMAP.
GGSCI (OGG1) 27> info trandata *
Logging of supplemental redo log data is enabled for table GG.COLMAP.
Columns supplementally logged for table GG.COLMAP: ID1.
目标端:
GGSCI (og2) 76> add trandata gg.colmap
Logging of supplemental redo data enabled for table REGG.COLMAP.
GGSCI (og2) 77> info trandata *
Logging of supplemental redo log data is enabled for table REGG.CHKPOINT.
Columns supplementally logged for table REGG.CHKPOINT: GROUP_NAME, GROUP_KEY.
Logging of supplemental redo log data is enabled for table REGG.CHKPOINT_LOX.
Columns supplementally logged for table REGG.CHKPOINT_LOX: GROUP_NAME, GROUP_KEY, LOG_CMPLT_CSN, LOG_CMPLT_XIDS_SEQ.
Logging of supplemental redo log data is enabled for table REGG.COLMAP.
Columns supplementally logged for table REGG.COLMAP: ID1.
在源端抽取进程和推送进程加入表:
TABLE GG.colmap;
在目标端复制进程加入表:
map gg.colmap,target regg.colmap,colmap(USEDEFAULTS id1=id3,id2=id1,id3=id2);
已经做了列变换
在源端插入数据:
insert into colmap values (1,2,3)
目标端:
实验完成:
字符类型也完成内部转换
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1199672/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764973/viewspace-1199672/