goldengate（14）--goldengate支持所有的DDL复制普通表（包含大对象字段）

各OGG进程参数文件如下:

extract抽取进程增加DDL配置

EXTRACT s_ex_hr
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
DBOPTIONS ALLOWUNUSEDCOLUMN
USERID ggs, PASSWORD ggs
TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/hr/tt
--TABLEEXCLUDE test.MV_123, test.mlog$_xy101
SEQUENCE gis_test.*;
DDL INCLUDE MAPPED OBJNAME "gis_test.*"
TABLE gis_test.*;

extract pump进程配置：

EXTRACT pump_hr
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
USERID ggs, PASSWORD ggs
RMTHOST 10.23.5.71, MGRPORT 7809
RMTTRAIL /u01/app/oracle/ggs/dirdat/rtrail/hr/pp
PASSTHRU
--TABLEEXCLUDE test.MV_123, test.mlog$_xy101
SEQUENCE gis_test.*;
TABLE gis_test.*;

目标端操作：

replicat复制进程配置：

REPLICAT rep_hr
SETENV (ORACLE_HOME = "/u01/app/oracle/product/10.2.0/db_1")
SETENV (ORACLE_SID = "dbwdn")
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/ggs/dirrpt/discard/rep.dsc, APPEND
USERID ggs, PASSWORD ggs
DDL INCLUDE MAPPED
MAP gis_test.*, TARGET gis_test.*;

示例：

 创建包含大对象字段的堆表

源端操作

create table gis_test.t2 (id number primary key ,a blob,b clob,c nclob,d long,e raw(20));

表GIS_TEST.T2的结构

SQL> desc gis_test.t2
Name Type    Nullable Default Comments
---- ------- -------- ------- --------
ID   NUMBER                           
A    BLOB    Y                        
B    CLOB    Y                        
C    NCLOB   Y                        
D    LONG    Y                        
E    RAW(20) Y         

目标端看到包含大对象字段的表结构

SQL> desc gis_test.t2
Name Type    Nullable Default Comments
---- ------- -------- ------- --------
ID   NUMBER                           
A    BLOB    Y                        
B    CLOB    Y                        
C    NCLOB   Y                        
D    LONG    Y                        
E    RAW(20) Y