目錄
- 標題與著作權資訊
- 前言
- Oracle GoldenGate
- Oracle GoldenGate 參數
GLOBALS參數摘要- 擷取參數摘要
- Replicat 參數摘要
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的TABLE- 適用於 Replicat 的
TABLE 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 程式