goldengate 同步部分列

源端的表有lob类型的字段，为了降低延迟，可以不同步这些列，只需要在源端的抽取进程中添加COLSEXCEPT参数即可，目标端不需其他设置，对lob和非lob字段都进行测试，可以不抽取，测试过程如下：
源端目标端表一致：
create table ogg_test(id number primary key,name varchar2(20),info clob);
源端抽取进程参数：
[code]GGSCI (localhost.localdomain) 53> info all


Program Status Group Lag at Chkpt Time Since Chkpt


MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING AWEN_EXT 00:00:00 00:00:08
EXTRACT RUNNING AWEN_PMP 00:00:00 00:00:00
REPLICAT RUNNING AWEN_REP 00:00:00 00:00:04


GGSCI (localhost.localdomain) 54> view params AWEN_EXT
EXTRACT awen_ext
USERID ogguser,PASSWORD ogguser
EXTTRAIL ./dirdat/va
TABLE awen.ogg_test,KEYCOLS(ID),COLSEXCEPT(info);[/code]
源端投递进程：
[code]GGSCI (localhost.localdomain) 55> view params AWEN_PMP
EXTRACT awen_pmp
USERID ogguser,PASSWORD ogguser
RMTHOST 127.0.0.1,MGRPORT 7848,COMPRESS
RMTTRAIL ./dirdat/vb
TABLE awen.*;[/code]
目标端复制进程：
[code]GGSCI (localhost.localdomain) 56> view params AWEN_REP
replicat awen_rep
ASSUMETARGETDEFS
USERID ogguser, PASSWORD ogguser
DISCARDFILE ./dirrpt/awen_rep.dsc, PURGE
map awen.ogg_test, target scott.ogg_test;[/code]
测试数据：
[code]SQL> insert into ogg_test(id ,name) values(10001,'Steven');
1 row created.
SQL> insert into ogg_test select 10002,'Jobs',rpad('awen',32767,'o') from dual;
1 row created.
SQL> insert into ogg_test select 10003,'Eygle',rpad('awen',32767,'b') from dual;
1 row created.

SQL> commit;

Commit complete.[/code]
目标端数据：
[code]SQL> select id,name,length(info) from ogg_test;



ID NAME LENGTH(INFO)
---------- -------------------- ------------
10001 Steven
10002 Jobs
10003 Eygle[/code]
另外对name字段也进行了测试，也是可以的。