设为首页 加入收藏

TOP

Oracle GoldenGate常用参数详解(八)
2017-09-19 14:34:59 】 浏览:9726
Tags:Oracle GoldenGate 常用 参数 详解
sp;           Controls the extraction of update operations 是否复制update操作,缺省复制


REPLACEBADCHAR                    Replaces invalid character values with another value.


SEQUENCE                          Specifies sequences for synchronization.


TABLE for Extract                  Specifies tables for extraction and controls column mapping and conversion.


TABLEEXCLUDE                      Excludes tables from the extraction process.
                                  定义所需要排除的表。如果在table里面定义了使用通配符,那么可以使用该参数定义排除掉其中的部分???。如:
                                  tableexclude ctais2.TMP_*;
                                  tableexclude ctais2.TEMPTAB;


TARGETDEFS                Specifies a file containing target table definitions for target databases that reside on the NonStop platform.


TRIMSPACES |
NOTRIMSPACES              Controls whether trailing spaces are trimmed or not when mapping  CHAR to  VARCHAR columns.


WILDCARDRESOLVE          Defines rules for processing wildcard table specifications in a  TABLE statement.


(5)数据转发 Routing data


EXTFILE        Specifies an extract file to which extracted data is written on the local system.


EXTTRAIL        Specifies a trail to which extracted data is written on the local system.
                指定写入到本地的哪个队列。
                示例:EXTTRAIL ./dirdat/ya      --本地队列文件路径


RMTFILE        Specifies an extract file to which extracted data is written on a remote system.


RMTHOST        Specifies the target system and Manager port number.
                指定目标系统及其GoldenGate Manager进程的端口号,也用于定义是否使用压缩进行传输。
                示例:rmthost  99.16.1.12,mgrport 7809, compress


RMTTRAIL        Specifies a trail to which extracted data is written on a remote system.
                指定写入到目标端的哪个队列


(6)数据格式化Formatting data


FORMATASCII      Formats extracted data in external ASCII format.


FORMATSQL        Formats extracted data into equivalent SQL statements.


FORMATXML        Formats extracted data into equivalent XML syntax.


NOHEADERS        Prevents record headers from being written to the trail.


(7)自定义处理 Custom processing


CUSEREXIT          Invokes a user exit routine during processing.


INCLUDE            Invokes a macro library.


MACRO              Defines an Oracle GoldenGate macro.


MACROCHAR          Defines a macro character other than the default of #.


SQLEXEC      &nb

首页 上一页 5 6 7 8 9 10 下一页 尾页 8/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle RMAN 自动恢复 下一篇MySQL ODBC 驱动安装

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目