目录
- 标题和版权信息
- 前言
- Oracle GoldenGate
- Oracle GoldenGate 参数
GLOBALS参数概要- 提取参数汇总
- 复制参数概要
ABORTDISCARDRECSALLOCFILESALLOWDUPTARGETMAP|NOALLOWDUPTARGETMAPALLOWINVISIBLEINDEXKEYSALLOWNULLABLEKEYS|NOALLOWNULLABLEKEYSALLOWNONVALIDATEDKEYSALLOWNOOPUPDATES|NOALLOWNOOPUPDATESAPPLYNOOPUPDATES|NOAPPLYNOOPUPDATESAPPLY_PARALLELISM|MAX_APPLY_PARALLELISM|MIN_APPLY_PARALLELISMASCIITOEBCDICASSUMETARGETDEFSAUTOSCHEMAOPTIONSBATCHSQLBEGINBLOBMEMORYBINARY_JSON_FORMATBRCACHEMGRCATALOGEXCLUDECHARMAPCHECKPARAMSCHECKPOINTSECSCHECKPOINTTABLECHUNK_SIZECMDTRACECOLCHARSETCOLMATCHCOMPRESSDELETES|NOCOMPRESSDELETESCOMPRESSUPDATES|NOCOMPRESSUPDATESCOMMIT_SERIALIZATIONCOORDSTATINTERVALCOORDTIMERCRYPTOENGINECUSEREXITDBOPTIONSDDLDDLERRORDDLOPTIONSDDLSUBSTDDLTABLEDECRYPTTRAILDEFERAPPLYINTERVALDEFSFILEDIAGLOGRECSDICTIONARY_CACHE_SIZEDISCARDFILE|NODISCARDFILEDISCARDROLLOVERDYNAMICRESOLUTION|NODYNAMICRESOLUTIONEBCDICTOASCIIENABLEMONITORINGENABLE_HEARTBEAT_TABLE|DISABLE_HEARTBEAT_TABLEENCRYPTTRAIL|NOENCRYPTTRAILENDEOFDELAY|EOFDELAYCSECSEXCLUDEHIDDENCOLUMNSEXCLUDETAGEXCLUDEWILDCARDOBJECTSONLYEXTFILEEXTRACTEXTTRAILFETCHOPTIONSFETCHUSERIDALIASFILTERDUPS|NOFILTERDUPSFILEGROUPFLUSHSECS|FLUSHCSECSFUNCTIONSTACKSIZEGETDELETES|IGNOREDELETESGETINSERTS|IGNOREINSERTSGETTRUNCATES|IGNORETRUNCATESGETUPDATEAFTERS|IGNOREUPDATEAFTERSGETUPDATEBEFORES|IGNOREUPDATEBEFORESGETUPDATES|IGNOREUPDATESGGSCHEMAGROUPTRANSOPSHANDLECOLLISIONS|NOHANDLECOLLISIONSHAVEUDTWITHNCHARHEARTBEATTABLEINCLUDEINCLUDETAGINITIALLOADOPTIONSINSERTALLRECORDSINSERTAPPEND|NOINSERTAPPENDINSERTDELETES|NOINSERTDELETESINSERTMISSINGUPDATES|NOINSERTMISSINGUPDATESINSERTUPDATES|NOINSERTUPDATESINSERTUPSERTS|NOINSERTUPSERTSLIST|NOLISTLOGALLSUPCOLSLOOK_AHEAD_TRANSACTIONSLOGOUT_RECV_TIMEOUTLRSNTIMEDELTAMACROMACROCHARMAP用于提取MAPMAPALLCOLUMNS|NOMAPALLCOLUMNSMAP_PARALLELISMMAPEXCLUDEMAPINVISIBLECOLUMNS|NOMAPINVISIBLECOLUMNSMASTERKEYNAMEMAXDISCARDRECSMAXGROUPSMAXSQLSTATEMENTSMAXTRANSOPSMGRSERVNAMENAMECCSIDNAMEMATCH参数NLS_LENGTH_SEMANTICSNOCATALOGNODUPMSGSUPPRESSIONNUMFILESNOUSERIDOBEYOUTPUTFILEUMASKOUTPUTFORMATOVERRIDEDUPS|NOOVERRIDEDUPSPARTITION|PARTITIONEXCLUDEPTKMONITORFREQUENCYPRESERVETARGETTIMEZONEPROCEDUREREPERRORREPFETCHEDCOLOPTIONSREPLACEBADCHARREPLACEBADNUMREPLICATREPORTREPORTCOUNTREPORTROLLOVERRESTARTCOLLISIONS|NORESTARTCOLLISIONSRMTFILEROLLOVERRMTTRAILSCHEMAEXCLUDESEQUENCESESSIONCHARSETSETENVSOURCECATALOGSOURCECHARSETSOURCEDEFSSOURCEISTABLESOURCETIMEZONESPACESTONULL|NOSPACESTONULLSPECIALRUNSPLIT_TRANS_RECSSQLDUPERRSQLEXECSTATOPTIONSTABLE|MAPDEFGEN的TABLETABLE表示复制TABLEEXCLUDETARGETDDLNOTIFY|NOTARGETDDLNOTIFYTARGETDEFSTCPSOURCETIMER|NOTCPSOURCETIMERTRAILBYTEORDERTRAILCHARSETTRAILCHARSETASCIITRAILCHARSETEBCDICTRANLOGOPTIONSTRANSACTIONTIMEOUTTRIMSPACES|NOTRIMSPACESTRIMVARSPACES|NOTRIMVARSPACESUPDATEDELETES|NOUPDATEDELETESUPDATEINSERTS|NOUPDATEINSERTSUPDATERECORDFORMATUSEDEDICATEDCOORDINATIONTHREADUSEIPV4|USEIPV6USERIDALIASVARWIDTHNCHAR|NOVARWIDTHNCHARWARNLONGTRANSWARNRATEWILDCARDRESOLVEY2KCENTURYADJUSTMENT|NOY2KCENTURYADJUSTMENT
- 表和列映射函数
- 列转换函数概要
@AISERVICE@RANGE@AFTER@BEFORE@BEFOREAFTER@BINARY@BINTOBASE64@BINTOHEX@CASE@COLSTAT@COLTEST@COMPUTE@DATE@DBFUNCTION@DATEDIFF@DATENOW@DDL@EVAL@GETENV@GETVAL@HEXTOBIN@HIGHVAL|LOWVAL@IF@NUMBIN@NUMSTR@OGG_SHA1@STRCAT@STRCMP@STRCMPNULL@STREQ@STREQNULL@STREXT@STRFIND@STRLEN@STRLTRIM@STRNCAT@STRNCMP@STRNUM@STRRTRIM@STRSUB@STRTRIM@STRUP@TOKEN@VALONEOF
- 用户出口函数
- 用户出口功能概要
- 调用用户出口
- 使用
EXIT_CALL_TYPE - 使用
EXIT_CALL_RESULT - 使用
EXIT_PARAMS - 使用
ERCALLBACK - 函数代码
COMPRESS_RECORDDECOMPRESS_RECORDGET_BASE_OBJECT_NAMEGET_BASE_OBJECT_NAME_ONLYGET_BASE_SCHEMA_NAME_ONLYGET_BEFORE_AFTER_INDGET_CATALOG_NAME_ONLYGET_COL_METADATA_FROM_INDEXGET_COL_METADATA_FROM_NAMEGET_COLUMN_INDEX_FROM_NAMEGET_COLUMN_NAME_FROM_INDEXGET_COLUMN_VALUE_FROM_INDEXGET_COLUMN_VALUE_FROM_NAMEGET_DATABASE_METADATAGET_DDL_RECORD_PROPERTIESGLOSSARYGET_ENV_VALUEGET_ERROR_INFOGET_GMT_TIMESTAMPGET_MARKER_INFOGET_OBJECT_NAMEGET_OBJECT_NAME_ONLYGET_OPERATION_TYPEGET_POSITIONGET_RECORD_BUFFERGET_RECORD_LENGTHGET_RECORD_TYPEGET_SCHEMA_NAME_ONLYGET_SESSION_CHARSETGET_STATISTICSGET_TABLE_COLUMN_COUNTGET_TABLE_METADATAGET_TABLE_NAMEGET_TABLE_NAME_ONLYGET_TIMESTAMPGET_TRANSACTION_INDGET_USER_TOKEN_VALUEOUTPUT_MESSAGE_TO_REPORTRESET_USEREXIT_STATSSET_COLUMN_VALUE_BY_INDEXSET_COLUMN_VALUE_BY_NAMESET_OPERATION_TYPESET_RECORD_BUFFERSET_SESSION_CHARSETSET_TABLE_NAME
- Oracle GoldenGate 计划