Go to main content
1/355
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
Conventions
Part I
Oracle GoldenGate
Classic Architecture
1
Collector Parameters
1.1
Overview of the Collector Process
1.2
Summary of Collector Parameters
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 Parameters
2.1
Summary of Manager Parameters
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
PURGEOLDEXTRACTS for Extract and Replicat
2.20
PURGEOLDEXTRACTS for Manager
2.21
PURGEOLDTASKS
2.22
STARTUPVALIDATIONDELAY[CSECS]
2.23
USERIDALIAS
2.24
VERIDATAREPORTAGE
3
Oracle GoldenGate Native Commands
3.1
Summary of Oracle GoldenGate IBM i Native Commands
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 Commands
4.1
GGSCI Command Interface
Part II
Oracle GoldenGate
Microservices Architecture
5
Oracle GoldenGate AdminClient Commands
5.1
AdminClient Commands
Part III
Oracle GoldenGate
Common Components
6
Oracle GoldenGate Parameters
6.1
Summary of Oracle GoldenGate Parameters
6.1.1
Summary of GLOBALS Parameters
6.1.2
Summary of Parameters Common to Extract and Replicat
6.1.3
Summary of Extract Parameters
6.1.4
Summary of Replicat Parameters
6.1.5
Summary of Wildcard Exclusion Parameters
6.1.6
Summary of DEFGEN Parameters
6.1.7
Summary of DDL Parameters
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
DYNAMICRESOLUTION | NODYNAMICRESOLUTION
6.50
EBCDICTOASCII
6.51
ENABLEMONITORING
6.52
ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
6.53
ENCRYPTTRAIL | NOENCRYPTTRAIL
6.54
END
6.55
EOFDELAY | EOFDELAYCSECS
6.56
EXCLUDEHIDDENCOLUMNS
6.57
EXCLUDETAG
6.58
EXCLUDEWILDCARDOBJECTSONLY
6.59
EXTFILE
6.60
EXTRACT
6.61
EXTTRAIL
6.62
FETCHOPTIONS
6.63
FETCHUSERID
6.64
FETCHUSERIDALIAS
6.65
FILTERDUPS | NOFILTERDUPS
6.66
FLUSHSECS | FLUSHCSECS
6.67
FUNCTIONSTACKSIZE
6.68
GENLOADFILES
6.69
GETAPPLOPS | IGNOREAPPLOPS
6.70
GETDELETES | IGNOREDELETES
6.71
GETINSERTS | IGNOREINSERTS
6.72
GETREPLICATES | IGNOREREPLICATES
6.73
GETTRUNCATES | IGNORETRUNCATES
6.74
GETUPDATEAFTERS | IGNOREUPDATEAFTERS
6.75
GETUPDATEBEFORES | IGNOREUPDATEBEFORES
6.76
GETUPDATES | IGNOREUPDATES
6.77
GGSCHEMA
6.78
GROUPTRANSOPS
6.79
HANDLECOLLISIONS | NOHANDLECOLLISIONS
6.80
HANDLETPKUPDATE
6.81
HAVEUDTWITHNCHAR
6.82
HEARTBEATTABLE
6.83
INCLUDE
6.84
INSERTALLRECORDS
6.85
INSERTAPPEND | NOINSERTAPPEND
6.86
INSERTDELETES | NOINSERTDELETES
6.87
INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
6.88
INSERTUPDATES | NOINSERTUPDATES
6.89
LIST | NOLIST
6.90
LOBMEMORY
6.91
LOGALLSUPCOLS
6.92
LOOK_AHEAD_TRANSACTIONS
6.93
MACRO
6.94
MACROCHAR
6.95
MAP for Extract
6.96
MAP
6.97
MAPALLCOLUMNS| NOMAPALLCOLUMNS
6.98
MAP_PARALLELISM
6.99
MAPEXCLUDE
6.100
MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
6.101
MARKERTABLE
6.102
MARKERTABLE
6.103
MAXDISCARDRECS
6.104
MAXGROUPS
6.105
MAXSQLSTATEMENTS
6.106
MAXTRANSOPS
6.107
MGRSERVNAME
6.108
NAMECCSID
6.109
NAMEMATCH parameters
6.110
NOCATALOG
6.111
NODUPMSGSUPPRESSION
6.112
NUMFILES
6.113
OBEY
6.114
OUTPUTFILEUMASK
6.115
OUTPUTFORMAT
6.116
OVERRIDEDUPS | NOOVERRIDEDUPS
6.117
PTKCAPTUREPROCSTATS
6.118
PTKMONITORFREQUENCY
6.119
PRESERVETARGETTIMEZONE
6.120
PROCEDURE
6.121
RECOVERYOPTIONS
6.122
REPERROR
6.123
REPFETCHEDCOLOPTIONS
6.124
REPLACEBADCHAR
6.125
REPLACEBADNUM
6.126
REPLICAT
6.127
REPORT
6.128
REPORTCOUNT
6.129
REPORTROLLOVER
6.130
REPOUDPPORT
6.131
RESTARTCOLLISIONS | NORESTARTCOLLISIONS
6.132
RMTFILE
6.133
RMTHOST
6.134
RMTHOSTOPTIONS
6.135
RMTTASK
6.136
RMTTRAIL
6.137
ROLLOVER
6.138
SCHEMAEXCLUDE
6.139
SEQUENCE
6.140
SESSIONCHARSET
6.141
SETENV
6.142
SHOWSYNTAX
6.143
SOURCEDB
6.144
SOURCECATALOG
6.145
SOURCECHARSET
6.146
SOURCEDEFS
6.147
SOURCEISTABLE
6.148
SOURCETIMEZONE
6.149
SPACESTONULL | NOSPACESTONULL
6.150
SPECIALRUN
6.151
SPLIT_TRANS_REC
6.152
SQLDUPERR
6.153
SQLEXEC
6.154
STATOPTIONS
6.155
TABLE | MAP
6.156
TABLE for DEFGEN
6.157
TABLE for Replicat
6.158
TABLEEXCLUDE
6.159
TARGETDB
6.160
TARGETDEFS
6.161
TCPSOURCETIMER | NOTCPSOURCETIMER
6.162
THREADOPTIONS
6.163
TRACE | TRACE2
6.164
TRACETABLE | NOTRACETABLE
6.165
TRAILBYTEORDER
6.166
TRAILCHARSET
6.167
TRAILCHARSETASCII
6.168
TRAILCHARSETEBCDIC
6.169
TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
6.170
TRANLOGOPTIONS
6.171
TRANSACTIONTIMEOUT
6.172
TRANSMEMORY
6.173
TRIMSPACES | NOTRIMSPACES
6.174
TRIMVARSPACES | NOTRIMVARSPACES
6.175
UPDATEDELETES | NOUPDATEDELETES
6.176
UPDATEINSERTS | NOUPDATEINSERTS
6.177
UPDATERECORDFORMAT
6.178
UPREPORT
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
Column Conversion Functions
7.1
Summary of Column-Conversion Functions
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
User Exit Functions
8.1
Calling a User Exit
8.2
Summary of User Exit Functions
8.3
Using EXIT_CALL_TYPE
8.4
Using EXIT_CALL_RESULT
8.5
Using EXIT_PARAMS
8.6
Using ERCALLBACK
8.7
Function Codes
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
Scripting on this page enhances content navigation, but does not change the content in any way.