目次
- タイトルおよび著作権情報
- はじめに
- 1 Oracle GoldenGateを使用するための前提条件
-
第I部 Oracle GoldenGateの共通コンポーネント
-
2 Oracle GoldenGateパラメータ
- 2.1 Oracle GoldenGateパラメータの概要
- 2.2 ABORTDISCARDRECS
- 2.3 ALLOCFILES
- 2.4 ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
- 2.5 ALLOWINVISIBLEINDEXKEYS
- 2.6 ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
- 2.7 ALLOWNONVALIDATEDKEYS
- 2.8 ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
- 2.9 ALLOWOUTPUTDIR
- 2.10 APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
- 2.11 APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
- 2.12 ASCIITOEBCDIC
- 2.13 ASSUMETARGETDEFS
- 2.14 BATCHSQL
- 2.15 BEGIN
- 2.16 BLOBMEMORY
- 2.17 BR
- 2.18 BULKLOAD
- 2.19 CACHEMGR
- 2.20 CATALOGEXCLUDE
- 2.21 CHARMAP
- 2.22 CHECKPARAMS
- 2.23 CHECKPOINTSECS
- 2.24 CHECKPOINTTABLE
- 2.25 CHUNK_SIZE
- 2.26 CMDTRACE
- 2.27 COLCHARSET
- 2.28 COLMATCH
- 2.29 COMPRESSDELETES | NOCOMPRESSDELETES
- 2.30 COMPRESSUPDATES | NOCOMPRESSUPDATES
- 2.31 COMMIT_SERIALIZATION
- 2.32 COORDSTATINTERVAL
- 2.33 COORDTIMER
- 2.34 CREDENTIALSTORELOCATION
- 2.35 CRYPTOENGINE
- 2.36 CUSEREXIT
- 2.37 DBOPTIONS
- 2.38 DDL
- 2.39 DDLERROR
- 2.40 DDLOPTIONS
- 2.41 DDLSUBST
- 2.42 DDLRULEHINT
- 2.43 DDLTABLE
- 2.44 DECRYPTTRAIL
- 2.45 DEFERAPPLYINTERVAL
- 2.46 DEFSFILE
- 2.47 DISCARDFILE | NODISCARDFILE
- 2.48 DISCARDROLLOVER
- 2.49 DYNAMICRESOLUTION | NODYNAMICRESOLUTION
- 2.50 EBCDICTOASCII
- 2.51 ENABLEMONITORING
- 2.52 ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
- 2.53 ENCRYPTTRAIL | NOENCRYPTTRAIL
- 2.54 END
- 2.55 EOFDELAY | EOFDELAYCSECS
- 2.56 EXCLUDEHIDDENCOLUMNS
- 2.57 EXCLUDETAG
- 2.58 EXCLUDEWILDCARDOBJECTSONLY
- 2.59 EXTFILE
- 2.60 EXTRACT
- 2.61 EXTTRAIL
- 2.62 FETCHOPTIONS
- 2.63 FETCHUSERID
- 2.64 FETCHUSERIDALIAS
- 2.65 FILTERDUPS | NOFILTERDUPS
- 2.66 FLUSHSECS | FLUSHCSECS
- 2.67 FUNCTIONSTACKSIZE
- 2.68 GETAPPLOPS | IGNOREAPPLOPS
- 2.69 GETDELETES | IGNOREDELETES
- 2.70 GETINSERTS | IGNOREINSERTS
- 2.71 GETREPLICATES | IGNOREREPLICATES
- 2.72 GETTRUNCATES | IGNORETRUNCATES
- 2.73 GETUPDATEAFTERS | IGNOREUPDATEAFTERS
- 2.74 GETUPDATEBEFORES | IGNOREUPDATEBEFORES
- 2.75 GETUPDATES | IGNOREUPDATES
- 2.76 GGSCHEMA
- 2.77 GROUPTRANSOPS
- 2.78 HANDLECOLLISIONS | NOHANDLECOLLISIONS
- 2.79 HANDLETPKUPDATE
- 2.80 HAVEUDTWITHNCHAR
- 2.81 HEARTBEATTABLE
- 2.82 INCLUDE
- 2.83 INSERTALLRECORDS
- 2.84 INSERTAPPEND | NOINSERTAPPEND
- 2.85 INSERTDELETES | NOINSERTDELETES
- 2.86 INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- 2.87 INSERTUPDATES | NOINSERTUPDATES
- 2.88 LIST | NOLIST
- 2.89 LOBMEMORY
- 2.90 LOGALLSUPCOLS
- 2.91 LOOK_AHEAD_TRANSACTIONS
- 2.92 MACRO
- 2.93 MACROCHAR
- 2.94 Extract用MAP
- 2.95 MAP
- 2.96 MAPALLCOLUMNS| NOMAPALLCOLUMNS
- 2.97 MAP_PARALLELISM
- 2.98 MAPEXCLUDE
- 2.99 MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
- 2.100 MARKERTABLE
- 2.101 MARKERTABLE
- 2.102 MAXDISCARDRECS
- 2.103 MAXGROUPS
- 2.104 MAXSQLSTATEMENTS
- 2.105 MAXTRANSOPS
- 2.106 MGRSERVNAME
- 2.107 NAMECCSID
- 2.108 NAMEMATCHパラメータ
- 2.109 NOCATALOG
- 2.110 NODUPMSGSUPPRESSION
- 2.111 NUMFILES
- 2.112 OBEY
- 2.113 OUTPUTFILEUMASK
- 2.114 OUTPUTFORMAT
- 2.115 OVERRIDEDUPS | NOOVERRIDEDUPS
- 2.116 PTKCAPTUREPROCSTATS
- 2.117 PTKMONITORFREQUENCY
- 2.118 PRESERVETARGETTIMEZONE
- 2.119 PROCEDURE
- 2.120 RECOVERYOPTIONS
- 2.121 REPERROR
- 2.122 REPFETCHEDCOLOPTIONS
- 2.123 REPLACEBADCHAR
- 2.124 REPLACEBADNUM
- 2.125 REPLICAT
- 2.126 REPORT
- 2.127 REPORTCOUNT
- 2.128 REPORTROLLOVER
- 2.129 REPOUDPPORT
- 2.130 RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- 2.131 RMTFILE
- 2.132 RMTHOST
- 2.133 RMTHOSTOPTIONS
- 2.134 RMTTASK
- 2.135 RMTTRAIL
- 2.136 ROLLOVER
- 2.137 SCHEMAEXCLUDE
- 2.138 SEQUENCE
- 2.139 SESSIONCHARSET
- 2.140 SETENV
- 2.141 SHOWSYNTAX
- 2.142 SOURCEDB
- 2.143 SOURCECATALOG
- 2.144 SOURCECHARSET
- 2.145 SOURCEDEFS
- 2.146 SOURCEISTABLE
- 2.147 SOURCETIMEZONE
- 2.148 SPACESTONULL | NOSPACESTONULL
- 2.149 SPECIALRUN
- 2.150 SPLIT_TRANS_REC
- 2.151 SQLDUPERR
- 2.152 SQLEXEC
- 2.153 STATOPTIONS
- 2.154 TABLE | MAP
- 2.155 DEFGEN用TABLE
- 2.156 Replicat用TABLE
- 2.157 TABLEEXCLUDE
- 2.158 TARGETDB
- 2.159 TARGETDEFS
- 2.160 TCPSOURCETIMER | NOTCPSOURCETIMER
- 2.161 THREADOPTIONS
- 2.162 TRACE | TRACE2
- 2.163 TRACETABLE | NOTRACETABLE
- 2.164 TRAILBYTEORDER
- 2.165 TRAILCHARSET
- 2.166 TRAILCHARSETASCII
- 2.167 TRAILCHARSETEBCDIC
- 2.168 TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
- 2.169 TRANLOGOPTIONS
- 2.170 TRANSACTIONTIMEOUT
- 2.171 TRANSMEMORY
- 2.172 TRIMSPACES | NOTRIMSPACES
- 2.173 TRIMVARSPACES | NOTRIMVARSPACES
- 2.174 UPDATEDELETES | NOUPDATEDELETES
- 2.175 UPDATEINSERTS | NOUPDATEINSERTS
- 2.176 UPDATERECORDFORMAT
- 2.177 UPREPORT
- 2.178 USE_TRAILDEFS | NO_USE_TRAILDEFS
- 2.179 USEDEDICATEDCOORDINATIONTHREAD
- 2.180 USEIPV4
- 2.181 USEIPV6
- 2.182 USERID | NOUSERID
- 2.183 USERIDALIAS
- 2.184 VAM
- 2.185 VARWIDTHNCHAR | NOVARWIDTHNCHAR
- 2.186 WALLETLOCATION
- 2.187 WARNLONGTRANS
- 2.188 WARNRATE
- 2.189 WILDCARDRESOLVE
- 2.190 XAGENABLE
- 2.191 Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
-
3 列変換ファンクション
- 3.1 列変換ファンクションの概要
- 3.2 @RANGE
- 3.3 AFTER
- 3.4 BEFORE
- 3.5 BEFOREAFTER
- 3.6 BINARY
- 3.7 BINTOHEX
- 3.8 CASE
- 3.9 COLSTAT
- 3.10 COLTEST
- 3.11 COMPUTE
- 3.12 DATE
- 3.13 DATEDIFF
- 3.14 DATENOW
- 3.15 DDL
- 3.16 EVAL
- 3.17 GETENV
- 3.18 GETVAL
- 3.19 HEXTOBIN
- 3.20 HIGHVAL | LOWVAL
- 3.21 IF
- 3.22 NUMBIN
- 3.23 NUMSTR
- 3.24 OGG_SHA1
- 3.25 STRCAT
- 3.26 STRCMP
- 3.27 STRCMPNULL
- 3.28 STREQ
- 3.29 STREQNULL
- 3.30 STREXT
- 3.31 STRFIND
- 3.32 STRLEN
- 3.33 STRLTRIM
- 3.34 STRNCAT
- 3.35 STRNCMP
- 3.36 STRNUM
- 3.37 STRRTRIM
- 3.38 STRSUB
- 3.39 STRTRIM
- 3.40 STRUP
- 3.41 TOKEN
- 3.42 VALONEOF
-
4 ユーザー・イグジット・ファンクション
- 4.1 ユーザー・イグジットのコール
- 4.2 ユーザー・イグジット・ファンクションの概要
- 4.3 EXIT_CALL_TYPEの使用
- 4.4 EXIT_CALL_RESULTの使用
- 4.5 EXIT_PARAMSの使用
- 4.6 ERCALLBACKの使用
- 4.7 ファンクション・コード
- 4.8 COMPRESS_RECORD
- 4.9 DECOMPRESS_RECORD
- 4.10 GET_BASE_OBJECT_NAME
- 4.11 GET_BASE_OBJECT_NAME_ONLY
- 4.12 GET_BASE_SCHEMA_NAME_ONLY
- 4.13 GET_BEFORE_AFTER_IND
- 4.14 GET_CATALOG_NAME_ONLY
- 4.15 GET_COL_METADATA_FROM_INDEX
- 4.16 GET_COL_METADATA_FROM_NAME
- 4.17 GET_COLUMN_INDEX_FROM_NAME
- 4.18 GET_COLUMN_NAME_FROM_INDEX
- 4.19 GET_COLUMN_VALUE_FROM_INDEX
- 4.20 GET_COLUMN_VALUE_FROM_NAME
- 4.21 GET_DATABASE_METADATA
- 4.22 GET_DDL_RECORD_PROPERTIES
- 4.23 GETENV
- 4.24 GET_ENV_VALUE
- 4.25 GET_ERROR_INFO
- 4.26 GET_GMT_TIMESTAMP
- 4.27 GET_MARKER_INFO
- 4.28 GET_OBJECT_NAME
- 4.29 GET_OBJECT_NAME_ONLY
- 4.30 GET_OPERATION_TYPE
- 4.31 GET_POSITION
- 4.32 GET_RECORD_BUFFER
- 4.33 GET_RECORD_LENGTH
- 4.34 GET_RECORD_TYPE
- 4.35 GET_SCHEMA_NAME_ONLY
- 4.36 GET_SESSION_CHARSET
- 4.37 GET_STATISTICS
- 4.38 GET_TABLE_COLUMN_COUNT
- 4.39 GET_TABLE_METADATA
- 4.40 GET_TABLE_NAME
- 4.41 GET_TABLE_NAME_ONLY
- 4.42 GET_TIMESTAMP
- 4.43 GET_TRANSACTION_IND
- 4.44 GET_USER_TOKEN_VALUE
- 4.45 OUTPUT_MESSAGE_TO_REPORT
- 4.46 RESET_USEREXIT_STATS
- 4.47 SET_COLUMN_VALUE_BY_INDEX
- 4.48 SET_COLUMN_VALUE_BY_NAME
- 4.49 SET_OPERATION_TYPE
- 4.50 SET_RECORD_BUFFER
- 4.51 SET_SESSION_CHARSET
- 4.52 SET_TABLE_NAME
-
2 Oracle GoldenGateパラメータ
- 第II部 Oracle GoldenGate Microservices Architecture
-
第III部 Oracle GoldenGate Classic Architecture
- 6 Collectorパラメータ
-
7 Managerパラメータ
- 7.1 Managerパラメータの概要
- 7.2 ACCESSRULE
- 7.3 AUTORESTART
- 7.4 AUTOSTART
- 7.5 BOOTDELAYMINUTES
- 7.6 CHARSET
- 7.7 CHECKMINUTES
- 7.8 COMMENT | --
- 7.9 DOWNREPORT
- 7.10 DYNAMICPORTLIST
- 7.11 MONITORING_HEARTBEAT_TIMEOUT
- 7.12 LAGCRITICAL
- 7.13 LAGINFO
- 7.14 LAGREPORT
- 7.15 PURGEMARKERHISTORY
- 7.16 PORT
- 7.17 SOURCEDB
- 7.18 PURGEDDLHISTORY | PURGEDDLHISTORYALT
- 7.19 ExtractおよびReplicat用PURGEOLDEXTRACTS
- 7.20 Manager用PURGEOLDEXTRACTS
- 7.21 PURGEOLDTASKS
- 7.22 STARTUPVALIDATIONDELAY[CSECS]
- 7.23 USERIDALIAS
- 7.24 VERIDATAREPORTAGE
- 8 Oracle GoldenGateのネイティブ・コマンド
- 9 Oracle GoldenGate GGSCIコマンド