目次
- タイトルおよび著作権情報
- はじめに
- Oracle GoldenGate
- Oracle GoldenGateパラメータ
GLOBALSパラメータの概要- Extractパラメータのサマリー
- 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(Extract用)MAPMAPALLCOLUMNS|NOMAPALLCOLUMNSMAP_PARALLELISMMAPEXCLUDEMAPINVISIBLECOLUMNS|NOMAPINVISIBLECOLUMNSMASTERKEYNAMEMAXDISCARDRECSMAXGROUPSMAXSQLSTATEMENTSMAXTRANSOPSMGRSERVNAMENAMECCSIDNAMEMATCHパラメータNLS_LENGTH_SEMANTICSNOCATALOGNODUPMSGSUPPRESSIONNUMFILESNOUSERIDOBEYOUTPUTFILEUMASKOUTPUTFORMATOVERRIDEDUPS|NOOVERRIDEDUPSPARTITION|PARTITIONEXCLUDEPTKMONITORFREQUENCYPRESERVETARGETTIMEZONEPROCEDUREREPERRORREPFETCHEDCOLOPTIONSREPLACEBADCHARREPLACEBADNUMREPLICATREPORTREPORTCOUNTREPORTROLLOVERRESTARTCOLLISIONS|NORESTARTCOLLISIONSRMTFILEROLLOVERRMTTRAILSCHEMAEXCLUDESEQUENCESESSIONCHARSETSETENVSOURCECATALOGSOURCECHARSETSOURCEDEFSSOURCEISTABLESOURCETIMEZONESPACESTONULL|NOSPACESTONULLSPECIALRUNSPLIT_TRANS_RECSSQLDUPERRSQLEXECSTATOPTIONSTABLE|MAPTABLE(DEFGENの場合)TABLE(Replicat用)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プログラム