多表拆分:
在目标端有六个表,分别为:ta1、ta2、tb1、tb2、tc1、tc2,并有进程rep1。
> view params rep1
replicat rep1
....
gettruncates
map hr.*, target hr.*;
现将Rep1进程进行拆分,使rep1处理ta1、ta2、tb1,其它的则在Rep2处理。
关闭进程:
> stop rep1
修改进程:
> view params rep1
replicat rep1
....
gettruncates
map hr.ta*, target hr.*;
map hr.tb1, target hr.*;
> view params rep2
replicat rep2
....
gettruncates
mapexclude hr.ta*;
mapexclude hr.tb1;
map hr.*, target hr.*;
注册目标库Rep2进程:
> add replicat rep2,exttrail /oradata/ggs/dirdat/rp,checkpointtable ggs.ggsckpt
REPLICAT added.
开启目标库复制进程:
> start rep1
> start rep2
数据抽取进程:
EXTRACT ext2
USERID prd, PASSWORD prd
RMTHOST sodb02, MGRPORT 7809
RMTTRAIL /u01/oracle/goldengate/dirdat/aa
TABLE prd.ac_entry;
大表分成三个复制进程:
REPLICAT rep2
ASSUMETARGETDEFS
USERID prd,PASSWORD prd
MAP prd.ac_entry, TARGET prd.ac_entry, FILTER (@RANGE (1,3));
REPLICAT rep3
ASSUMETARGETDEFS
USERID prd,PASSWORD prd
MAP prd.ac_entry, TARGET prd.ac_entry, FILTER (@RANGE (2,3));
REPLICAT rep4
ASSUMETARGETDEFS
USERID prd,PASSWORD prd
MAP prd.ac_entry, TARGET prd.ac_entry, FILTER (@RANGE (3,3));