goldengate 配置源头 scott.* 到目的端scott2.*时,只是在目的端rep进程参数文件中指定即可

replicat screp
setenv ( NLS_LANG = " SIMPLIFIED CHINESE_CHINA.ZHS16GBK " )
assumetargetdefs
DBOPTIONS DEFERREFCONST
gettruncates
applynoopupdates
userid goldengate, password oracle
ddl include objname "scott.*" &
INCLUDE OBJTYPE 'USER'
ddlerror 600, ignore
discardfile ./dirrpt/scrini.dsc, append, megabytes 500
map scott.*, target scott2.*;

[@more@]
请使用浏览器的分享功能分享到微信等