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