プライマリ・コンテンツに移動
Oracle® Fusion Middleware Oracle GoldenGateリファレンス
12
c
(12.3.0.1)
E89930-05
次
目次
タイトルおよび著作権情報
はじめに
対象読者
ドキュメントのアクセシビリティについて
関連情報
表記規則
第I部
Oracle GoldenGate
Classic Architecture
1
Collectorパラメータ
1.1
Collectorプロセスの概要
1.2
Collectorパラメータの概要
1.3
-B
1.4
-b
1.5
-cp
1.6
-d
1.7
-E
1.8
-e
1.9
-ENCRYPT
1.10
-f
1.11
-g
1.12
-h
1.13
-k
1.14
-KEYNAME
1.15
-l
1.16
-m
1.17
-P
1.18
-p
1.19
-R
1.20
-x
2
Managerパラメータ
2.1
Managerパラメータの概要
2.2
ACCESSRULE
2.3
AUTORESTART
2.4
AUTOSTART
2.5
BOOTDELAYMINUTES
2.6
CHARSET
2.7
CHECKMINUTES
2.8
COMMENT | --
2.9
DOWNREPORT
2.10
DYNAMICPORTLIST
2.11
MONITORING_HEARTBEAT_TIMEOUT
2.12
LAGCRITICAL
2.13
LAGINFO
2.14
LAGREPORT
2.15
PURGEMARKERHISTORY
2.16
PORT
2.17
SOURCEDB
2.18
PURGEDDLHISTORY | PURGEDDLHISTORYALT
2.19
ExtractおよびReplicat用PURGEOLDEXTRACTS
2.20
Manager用PURGEOLDEXTRACTS
2.21
PURGEOLDTASKS
2.22
STARTUPVALIDATIONDELAY[CSECS]
2.23
USERIDALIAS
2.24
VERIDATAREPORTAGE
3
Oracle GoldenGateのネイティブ・コマンド
3.1
Oracle GoldenGate IBM iのネイティブ・コマンドの概要
3.2
checkprm
3.3
convchk
3.4
defgen
3.5
extract
3.6
ggsci
3.7
install
3.8
keygen
3.9
logdump
3.10
mgr
3.11
replicat
4
Oracle GoldenGate GGSCIコマンド
4.1
GGSCIコマンド・インタフェース
第II部
Oracle GoldenGate
Microservices Architecture
5
Oracle GoldenGate AdminClientコマンド
5.1
AdminClientコマンド
第III部
Oracle GoldenGate
の共通コンポーネント
6
Oracle GoldenGateパラメータ
6.1
Oracle GoldenGateパラメータの概要
6.1.1
GLOBALSパラメータの概要
6.1.2
ExtractとReplicatに共通のパラメータの概要
6.1.3
Extractパラメータの概要
6.1.4
Replicatパラメータの概要
6.1.5
ワイルドカード除外パラメータの概要
6.1.6
DEFGENパラメータの概要
6.1.7
DDLパラメータの概要
6.2
ABORTDISCARDRECS
6.3
ALLOCFILES
6.4
ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
6.5
ALLOWINVISIBLEINDEXKEYS
6.6
ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
6.7
ALLOWNONVALIDATEDKEYS
6.8
ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
6.9
ALLOWOUTPUTDIR
6.10
APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
6.11
APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
6.12
ASCIITOEBCDIC
6.13
ASSUMETARGETDEFS
6.14
BATCHSQL
6.15
BEGIN
6.16
BLOBMEMORY
6.17
BR
6.18
BULKLOAD
6.19
CACHEMGR
6.20
CATALOGEXCLUDE
6.21
CHARMAP
6.22
CHECKPARAMS
6.23
CHECKPOINTSECS
6.24
CHECKPOINTTABLE
6.25
CHUNK_SIZE
6.26
CMDTRACE
6.27
COLCHARSET
6.28
COLMATCH
6.29
COMPRESSDELETES | NOCOMPRESSDELETES
6.30
COMPRESSUPDATES | NOCOMPRESSUPDATES
6.31
COMMIT_SERIALIZATION
6.32
COORDSTATINTERVAL
6.33
COORDTIMER
6.34
CREDENTIALSTORELOCATION
6.35
CRYPTOENGINE
6.36
CUSEREXIT
6.37
DBOPTIONS
6.38
DDL
6.39
DDLERROR
6.40
DDLOPTIONS
6.41
DDLSUBST
6.42
DDLRULEHINT
6.43
DDLTABLE
6.44
DECRYPTTRAIL
6.45
DEFERAPPLYINTERVAL
6.46
DEFSFILE
6.47
DISCARDFILE | NODISCARDFILE
6.48
DISCARDROLLOVER
6.49
DSOPTIONS
6.50
DYNAMICRESOLUTION | NODYNAMICRESOLUTION
6.51
EBCDICTOASCII
6.52
ENABLEMONITORING
6.53
ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
6.54
ENCRYPTTRAIL | NOENCRYPTTRAIL
6.55
END
6.56
EOFDELAY | EOFDELAYCSECS
6.57
EXCLUDEHIDDENCOLUMNS
6.58
EXCLUDETAG
6.59
EXCLUDEWILDCARDOBJECTSONLY
6.60
EXTFILE
6.61
EXTRACT
6.62
EXTTRAIL
6.63
FETCHOPTIONS
6.64
FETCHUSERID
6.65
FETCHUSERIDALIAS
6.66
FILTERDUPS | NOFILTERDUPS
6.67
FLUSHSECS | FLUSHCSECS
6.68
FUNCTIONSTACKSIZE
6.69
GENLOADFILES
6.70
GETAPPLOPS | IGNOREAPPLOPS
6.71
GETDELETES | IGNOREDELETES
6.72
GETINSERTS | IGNOREINSERTS
6.73
GETREPLICATES | IGNOREREPLICATES
6.74
GETTRUNCATES | IGNORETRUNCATES
6.75
GETUPDATEAFTERS | IGNOREUPDATEAFTERS
6.76
GETUPDATEBEFORES | IGNOREUPDATEBEFORES
6.77
GETUPDATES | IGNOREUPDATES
6.78
GGSCHEMA
6.79
GROUPTRANSOPS
6.80
HANDLECOLLISIONS | NOHANDLECOLLISIONS
6.81
HANDLETPKUPDATE
6.82
HAVEUDTWITHNCHAR
6.83
HEARTBEATTABLE
6.84
INCLUDE
6.85
INSERTALLRECORDS
6.86
INSERTAPPEND | NOINSERTAPPEND
6.87
INSERTDELETES | NOINSERTDELETES
6.88
INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
6.89
INSERTUPDATES | NOINSERTUPDATES
6.90
LIST | NOLIST
6.91
LOBMEMORY
6.92
LOGALLSUPCOLS
6.93
LOOK_AHEAD_TRANSACTIONS
6.94
MACRO
6.95
MACROCHAR
6.96
Extract用MAP
6.97
MAP
6.98
MAPALLCOLUMNS| NOMAPALLCOLUMNS
6.99
MAP_PARALLELISM
6.100
MAPEXCLUDE
6.101
MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
6.102
MARKERTABLE
6.103
MARKERTABLE
6.104
MAXDISCARDRECS
6.105
MAXGROUPS
6.106
MAXSQLSTATEMENTS
6.107
MAXTRANSOPS
6.108
MGRSERVNAME
6.109
NAMECCSID
6.110
NAMEMATCH parameters
6.111
NOCATALOG
6.112
NODUPMSGSUPPRESSION
6.113
NUMFILES
6.114
OBEY
6.115
OUTPUTFILEUMASK
6.116
OUTPUTFORMAT
6.117
OVERRIDEDUPS | NOOVERRIDEDUPS
6.118
PTKCAPTUREPROCSTATS
6.119
PTKMONITORFREQUENCY
6.120
PRESERVETARGETTIMEZONE
6.121
PROCEDURE
6.122
RECOVERYOPTIONS
6.123
REPERROR
6.124
REPFETCHEDCOLOPTIONS
6.125
REPLACEBADCHAR
6.126
REPLACEBADNUM
6.127
REPLICAT
6.128
REPORT
6.129
REPORTCOUNT
6.130
REPORTROLLOVER
6.131
REPOUDPPORT
6.132
RESTARTCOLLISIONS | NORESTARTCOLLISIONS
6.133
RMTFILE
6.134
RMTHOST
6.135
RMTHOSTOPTIONS
6.136
RMTTASK
6.137
RMTTRAIL
6.138
ROLLOVER
6.139
SCHEMAEXCLUDE
6.140
SEQUENCE
6.141
SESSIONCHARSET
6.142
SETENV
6.143
SHOWSYNTAX
6.144
SOURCEDB
6.145
SOURCECATALOG
6.146
SOURCECHARSET
6.147
SOURCEDEFS
6.148
SOURCEISTABLE
6.149
SOURCETIMEZONE
6.150
SPACESTONULL | NOSPACESTONULL
6.151
SPECIALRUN
6.152
SPLIT_TRANS_REC
6.153
SQLDUPERR
6.154
SQLEXEC
6.155
STATOPTIONS
6.156
TABLE | MAP
6.157
DEFGEN用TABLE
6.158
Replicat用TABLE
6.159
TABLEEXCLUDE
6.160
TARGETDB
6.161
TARGETDEFS
6.162
TCPSOURCETIMER | NOTCPSOURCETIMER
6.163
THREADOPTIONS
6.164
TRACE | TRACE2
6.165
TRACETABLE | NOTRACETABLE
6.166
TRAILBYTEORDER
6.167
TRAILCHARSET
6.168
TRAILCHARSETASCII
6.169
TRAILCHARSETEBCDIC
6.170
TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
6.171
TRANLOGOPTIONS
6.172
TRANSACTIONTIMEOUT
6.173
TRANSMEMORY
6.174
TRIMSPACES | NOTRIMSPACES
6.175
TRIMVARSPACES | NOTRIMVARSPACES
6.176
UPDATEDELETES | NOUPDATEDELETES
6.177
UPDATEINSERTS | NOUPDATEINSERTS
6.178
UPDATERECORDFORMAT
6.179
USE_TRAILDEFS | NO_USE_TRAILDEFS
6.180
USEDEDICATEDCOORDINATIONTHREAD
6.181
USEIPV4
6.182
USEIPV6
6.183
USERID | NOUSERID
6.184
USERIDALIAS
6.185
VAM
6.186
VARWIDTHNCHAR | NOVARWIDTHNCHAR
6.187
WALLETLOCATION
6.188
WARNLONGTRANS
6.189
WARNRATE
6.190
WILDCARDRESOLVE
6.191
XAGENABLE
6.192
Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
7
列変換ファンクション
7.1
列変換ファンクションの概要
7.2
@RANGE
7.3
AFTER
7.4
BEFORE
7.5
BEFOREAFTER
7.6
BINARY
7.7
BINTOHEX
7.8
CASE
7.9
COLSTAT
7.10
COLTEST
7.11
COMPUTE
7.12
DATE
7.13
DATEDIFF
7.14
DATENOW
7.15
DDL
7.16
EVAL
7.17
GETENV
7.18
GETVAL
7.19
HEXTOBIN
7.20
HIGHVAL | LOWVAL
7.21
IF
7.22
NUMBIN
7.23
NUMSTR
7.24
OGG_SHA1
7.25
STRCAT
7.26
STRCMP
7.27
STRCMPNULL
7.28
STREQ
7.29
STREQNULL
7.30
STREXT
7.31
STRFIND
7.32
STRLEN
7.33
STRLTRIM
7.34
STRNCAT
7.35
STRNCMP
7.36
STRNUM
7.37
STRRTRIM
7.38
STRSUB
7.39
STRTRIM
7.40
STRUP
7.41
TOKEN
7.42
VALONEOF
8
ユーザー・イグジット・ファンクション
8.1
ユーザー・イグジットのコール
8.2
ユーザー・イグジット・ファンクションの概要
8.3
EXIT_CALL_TYPEの使用
8.4
EXIT_CALL_RESULTの使用
8.5
EXIT_PARAMSの使用
8.6
ERCALLBACKの使用
8.7
ファンクション・コード
8.8
COMPRESS_RECORD
8.9
DECOMPRESS_RECORD
8.10
GET_BASE_OBJECT_NAME
8.11
GET_BASE_OBJECT_NAME_ONLY
8.12
GET_BASE_SCHEMA_NAME_ONLY
8.13
GET_BEFORE_AFTER_IND
8.14
GET_CATALOG_NAME_ONLY
8.15
GET_COL_METADATA_FROM_INDEX
8.16
GET_COL_METADATA_FROM_NAME
8.17
GET_COLUMN_INDEX_FROM_NAME
8.18
GET_COLUMN_NAME_FROM_INDEX
8.19
GET_COLUMN_VALUE_FROM_INDEX
8.20
GET_COLUMN_VALUE_FROM_NAME
8.21
GET_DATABASE_METADATA
8.22
GET_DDL_RECORD_PROPERTIES
8.23
GETENV
8.24
GET_ENV_VALUE
8.25
GET_ERROR_INFO
8.26
GET_GMT_TIMESTAMP
8.27
GET_MARKER_INFO
8.28
GET_OBJECT_NAME
8.29
GET_OBJECT_NAME_ONLY
8.30
GET_OPERATION_TYPE
8.31
GET_POSITION
8.32
GET_RECORD_BUFFER
8.33
GET_RECORD_LENGTH
8.34
GET_RECORD_TYPE
8.35
GET_SCHEMA_NAME_ONLY
8.36
GET_SESSION_CHARSET
8.37
GET_STATISTICS
8.38
GET_TABLE_COLUMN_COUNT
8.39
GET_TABLE_METADATA
8.40
GET_TABLE_NAME
8.41
GET_TABLE_NAME_ONLY
8.42
GET_TIMESTAMP
8.43
GET_TRANSACTION_IND
8.44
GET_USER_TOKEN_VALUE
8.45
OUTPUT_MESSAGE_TO_REPORT
8.46
RESET_USEREXIT_STATS
8.47
SET_COLUMN_VALUE_BY_INDEX
8.48
SET_COLUMN_VALUE_BY_NAME
8.49
SET_OPERATION_TYPE
8.50
SET_RECORD_BUFFER
8.51
SET_SESSION_CHARSET
8.52
SET_TABLE_NAME
