--在目标端编辑def文件
defsfile ./dirdef/ggrep.defs
userid ogg, password ogg
table scott.*;
--生成defs文件
oracle@BJ-CP-7F-113-64:/home/oracle/install/ogg$ ./defgen paramfile GGREP.DEFS
--源端表结构
SQL> desc t3
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(10)
--目标端表结构
SQL> desc tt3
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME1 VARCHAR2(10)
---修改目标端replicat参数文件
replicat ggrep
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
GETENV (NLS_LANG)
SETENV (LANG=zh_CN.GBK)
GETENV (LANG)
SETENV (ORACLE_HOME=/home/db/oracle/product/11.2.0)
GETENV (ORACLE_HOME)
SETENV (ORACLE_SID=hndcx)
GETENV (ORACLE_SID)
userid ogg, password ogg
ddl include all
ddlerror default ignore retryop maxretries 3 retrydelay 5
REPORT AT 01:59
reportrollover at 02:00
reperror default,discard
discardfile ./dirrpt/ggrep.dsc, APPEND, MEGABYTES 1000
assumetargetdefs
allownoopupdates
dynamicresolution
numfiles 3000
map SCOTT.t1, target SCOTT.t1;
map SCOTT.t2, target SCOTT.t2;
map scott.t3, target scott.tt3 , colmap(usedefaults, "name1"="name");
--重启目标端replicat服务
defsfile ./dirdef/ggrep.defs
userid ogg, password ogg
table scott.*;
--生成defs文件
oracle@BJ-CP-7F-113-64:/home/oracle/install/ogg$ ./defgen paramfile GGREP.DEFS
--源端表结构
SQL> desc t3
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(10)
--目标端表结构
SQL> desc tt3
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME1 VARCHAR2(10)
---修改目标端replicat参数文件
replicat ggrep
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
GETENV (NLS_LANG)
SETENV (LANG=zh_CN.GBK)
GETENV (LANG)
SETENV (ORACLE_HOME=/home/db/oracle/product/11.2.0)
GETENV (ORACLE_HOME)
SETENV (ORACLE_SID=hndcx)
GETENV (ORACLE_SID)
userid ogg, password ogg
ddl include all
ddlerror default ignore retryop maxretries 3 retrydelay 5
REPORT AT 01:59
reportrollover at 02:00
reperror default,discard
discardfile ./dirrpt/ggrep.dsc, APPEND, MEGABYTES 1000
assumetargetdefs
allownoopupdates
dynamicresolution
numfiles 3000
map SCOTT.t1, target SCOTT.t1;
map SCOTT.t2, target SCOTT.t2;
map scott.t3, target scott.tt3 , colmap(usedefaults, "name1"="name");
--重启目标端replicat服务
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10972173/viewspace-2127271/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10972173/viewspace-2127271/