Table of Contents
- Title and Copyright Information
- Preface
-
Part I Oracle GoldenGate Common Components
-
1
Oracle GoldenGate Parameters
- 1.1 Summary of GLOBALS Parameters
- 1.2 Summary of Extract Parameters
- 1.3 Summary of Replicat Parameters
- 1.4 ABORTDISCARDRECS
- 1.5 ALLOCFILES
- 1.6 ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
- 1.7 ALLOWINVISIBLEINDEXKEYS
- 1.8 ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
- 1.9 ALLOWNONVALIDATEDKEYS
- 1.10 ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
- 1.11 APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
- 1.12 APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
- 1.13 ASCIITOEBCDIC
- 1.14 ASSUMETARGETDEFS
- 1.15 AUTORESTART
- 1.16 AUTOSTART
- 1.17 BATCHSQL
- 1.18 BEGIN
- 1.19 BLOBMEMORY
- 1.20 BINARY_JSON_FORMAT
- 1.21 BR
- 1.22 BULKLOAD
- 1.23 CACHEMGR
- 1.24 CATALOGEXCLUDE
- 1.25 CHARMAP
- 1.26 CHECKPARAMS
- 1.27 CHECKPOINTSECS
- 1.28 CHECKPOINTTABLE
- 1.29 CHUNK_SIZE
- 1.30 CMDTRACE
- 1.31 COLCHARSET
- 1.32 COLMATCH
- 1.33 COMPRESSDELETES | NOCOMPRESSDELETES
- 1.34 COMPRESSUPDATES | NOCOMPRESSUPDATES
- 1.35 COMMIT_SERIALIZATION
- 1.36 COORDSTATINTERVAL
- 1.37 COORDTIMER
- 1.38 CREDENTIALSTORELOCATION
- 1.39 CRYPTOENGINE
- 1.40 CUSEREXIT
- 1.41 DBOPTIONS
- 1.42 DDL
- 1.43 DDLERROR
- 1.44 DDLOPTIONS
- 1.45 DDLSUBST
- 1.46 DDLRULEHINT
- 1.47 DDLTABLE
- 1.48 DECRYPTTRAIL
- 1.49 DEFERAPPLYINTERVAL
- 1.50 DEFSFILE
- 1.51 DIAGLOGRECS
- 1.52 DICTIONARY_CACHE_SIZE
- 1.53 DISCARDFILE | NODISCARDFILE
- 1.54 DISCARDROLLOVER
- 1.55 DYNAMICRESOLUTION
- 1.56 EBCDICTOASCII
- 1.57 ENABLEMONITORING
- 1.58 ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
- 1.59 ENCRYPTTRAIL | NOENCRYPTTRAIL
- 1.60 END
- 1.61 EOFDELAY | EOFDELAYCSECS
- 1.62 EXCLUDEHIDDENCOLUMNS
- 1.63 EXCLUDETAG
- 1.64 EXCLUDEWILDCARDOBJECTSONLY
- 1.65 EXTFILE
- 1.66 EXTRACT
- 1.67 EXTTRAIL
- 1.68 FETCHOPTIONS
- 1.69 FETCHUSERID
- 1.70 FETCHUSERIDALIAS
- 1.71 FILTERDUPS | NOFILTERDUPS
- 1.72 FILEGROUP
- 1.73 FLUSHSECS | FLUSHCSECS
- 1.74 FUNCTIONSTACKSIZE
- 1.75 GETAPPLOPS | IGNOREAPPLOPS
- 1.76 GETDELETES | IGNOREDELETES
- 1.77 GETINSERTS | IGNOREINSERTS
- 1.78 GETREPLICATES | IGNOREREPLICATES
- 1.79 GETTRUNCATES | IGNORETRUNCATES
- 1.80 GETUPDATEAFTERS | IGNOREUPDATEAFTERS
- 1.81 GETUPDATEBEFORES | IGNOREUPDATEBEFORES
- 1.82 GETUPDATES | IGNOREUPDATES
- 1.83 GGSCHEMA
- 1.84 GROUPTRANSOPS
- 1.85 HANDLECOLLISIONS | NOHANDLECOLLISIONS
- 1.86 HAVEUDTWITHNCHAR
- 1.87 HEARTBEATTABLE
- 1.88 INCLUDE
- 1.89 INCLUDETAG
- 1.90 INITIALLOADOPTIONS
- 1.91 INSERTALLRECORDS
- 1.92 INSERTAPPEND | NOINSERTAPPEND
- 1.93 INSERTDELETES | NOINSERTDELETES
- 1.94 INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- 1.95 INSERTUPDATES | NOINSERTUPDATES
- 1.96 INSERTUPSERTS | NOINSERTUPSERTS
- 1.97 LIST | NOLIST
- 1.98 LOGALLSUPCOLS
- 1.99 LOOK_AHEAD_TRANSACTIONS
- 1.100 LOGOUT_RECV_TIMEOUT
- 1.101 LRSNTIMEDELTA
- 1.102 MACRO
- 1.103 MACROCHAR
- 1.104 MAP for Extract
- 1.105 MAP
- 1.106 MAPALLCOLUMNS| NOMAPALLCOLUMNS
- 1.107 MAP_PARALLELISM
- 1.108 MAPEXCLUDE
- 1.109 MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
- 1.110 MASTERKEYNAME
- 1.111 MAXDISCARDRECS
- 1.112 MAXGROUPS
- 1.113 MAXSQLSTATEMENTS
- 1.114 MAXTRANSOPS
- 1.115 MGRSERVNAME
- 1.116 NAMECCSID
- 1.117 NAMEMATCH parameters
- 1.118 NLS_LENGTH_SEMANTICS
- 1.119 NOCATALOG
- 1.120 NODUPMSGSUPPRESSION
- 1.121 NUMFILES
- 1.122 OBEY
- 1.123 OUTPUTFILEUMASK
- 1.124 OUTPUTFORMAT
- 1.125 OVERRIDEDUPS | NOOVERRIDEDUPS
- 1.126 PARTITION | PARTITIONEXCLUDE
- 1.127 PTKMONITORFREQUENCY
- 1.128 PRESERVETARGETTIMEZONE
- 1.129 PROCEDURE
- 1.130 PURGEOLDEXTRACTS for Extract and Replicat
- 1.131 REPERROR
- 1.132 REPFETCHEDCOLOPTIONS
- 1.133 REPLACEBADCHAR
- 1.134 REPLACEBADNUM
- 1.135 REPLICAT
- 1.136 REPORT
- 1.137 REPORTCOUNT
- 1.138 REPORTROLLOVER
- 1.139 REPOUDPPORT
- 1.140 RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- 1.141 RMTFILE
- 1.142 RMTHOST
- 1.143 RMTHOSTOPTIONS
- 1.144 RMTTRAIL
- 1.145 ROLLOVER
- 1.146 SCHEMAEXCLUDE
- 1.147 SEQUENCE
- 1.148 SESSIONCHARSET
- 1.149 SETENV
- 1.150 SOURCEDB
- 1.151 SOURCECATALOG
- 1.152 SOURCECHARSET
- 1.153 SOURCEDEFS
- 1.154 SOURCEISTABLE
- 1.155 SOURCETIMEZONE
- 1.156 SPACESTONULL | NOSPACESTONULL
- 1.157 SPECIALRUN
- 1.158 SPLIT_TRANS_RECS
- 1.159 SQLDUPERR
- 1.160 SQLEXEC
- 1.161 STATOPTIONS
- 1.162 TABLE | MAP
- 1.163 TABLE for DEFGEN
- 1.164 TABLE for Replicat
- 1.165 TABLEEXCLUDE
- 1.166 TARGETDB
- 1.167 TARGETDEFS
- 1.168 TCPSOURCETIMER | NOTCPSOURCETIMER
- 1.169 TRACE | TRACE2
- 1.170 TRACETABLE | NOTRACETABLE
- 1.171 TRAILBYTEORDER
- 1.172 TRAILCHARSET
- 1.173 TRAILCHARSETASCII
- 1.174 TRAILCHARSETEBCDIC
- 1.175 TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
- 1.176 TRANLOGOPTIONS
- 1.177 TRANSACTIONTIMEOUT
- 1.178 TRANSMEMORY
- 1.179 TRIMSPACES | NOTRIMSPACES
- 1.180 TRIMVARSPACES | NOTRIMVARSPACES
- 1.181 UPDATEDELETES | NOUPDATEDELETES
- 1.182 UPDATEINSERTS | NOUPDATEINSERTS
- 1.183 UPDATERECORDFORMAT
- 1.184 UPREPORTMINUTES | UPREPORTHOURS
- 1.185 USE_TRAILDEFS | NO_USE_TRAILDEFS
- 1.186 USEDEDICATEDCOORDINATIONTHREAD
- 1.187 USEIPV4 | USEIPV6
- 1.188 USERID | NOUSERID
- 1.189 USERIDALIAS
- 1.190 VARWIDTHNCHAR | NOVARWIDTHNCHAR
- 1.191 WALLETLOCATION
- 1.192 WARNLONGTRANS
- 1.193 WARNRATE
- 1.194 WILDCARDRESOLVE
- 1.195 XAGENABLE
- 1.196 Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
-
2
Column Conversion Functions
- 2.1 Summary of Column-Conversion Functions
- 2.2 @RANGE
- 2.3 @AFTER
- 2.4 @BEFORE
- 2.5 @BEFOREAFTER
- 2.6 @BINARY
- 2.7 @BINTOBASE64
- 2.8 @BINTOHEX
- 2.9 @CASE
- 2.10 @COLSTAT
- 2.11 @COLTEST
- 2.12 @COMPUTE
- 2.13 @DATE
- 2.14 @DATEDIFF
- 2.15 @DATENOW
- 2.16 @DDL
- 2.17 @EVAL
- 2.18 @GETENV
- 2.19 @GETVAL
- 2.20 @HEXTOBIN
- 2.21 @HIGHVAL | LOWVAL
- 2.22 @IF
- 2.23 @NUMBIN
- 2.24 @NUMSTR
- 2.25 @OGG_SHA1
- 2.26 @STRCAT
- 2.27 @STRCMP
- 2.28 @STRCMPNULL
- 2.29 @STREQ
- 2.30 @STREQNULL
- 2.31 @STREXT
- 2.32 @STRFIND
- 2.33 @STRLEN
- 2.34 @STRLTRIM
- 2.35 @STRNCAT
- 2.36 @STRNCMP
- 2.37 @STRNUM
- 2.38 @STRRTRIM
- 2.39 @STRSUB
- 2.40 @STRTRIM
- 2.41 @STRUP
- 2.42 @TOKEN
- 2.43 @VALONEOF
-
3
User Exit Functions
- 3.1 Summary of User Exit Functions
- 3.2 Calling a User Exit
- 3.3 Using EXIT_CALL_TYPE
- 3.4 Using EXIT_CALL_RESULT
- 3.5 Using EXIT_PARAMS
- 3.6 Using ERCALLBACK
- 3.7 Function Codes
- 3.8 COMPRESS_RECORD
- 3.9 DECOMPRESS_RECORD
- 3.10 GET_BASE_OBJECT_NAME
- 3.11 GET_BASE_OBJECT_NAME_ONLY
- 3.12 GET_BASE_SCHEMA_NAME_ONLY
- 3.13 GET_BEFORE_AFTER_IND
- 3.14 GET_CATALOG_NAME_ONLY
- 3.15 GET_COL_METADATA_FROM_INDEX
- 3.16 GET_COL_METADATA_FROM_NAME
- 3.17 GET_COLUMN_INDEX_FROM_NAME
- 3.18 GET_COLUMN_NAME_FROM_INDEX
- 3.19 GET_COLUMN_VALUE_FROM_INDEX
- 3.20 GET_COLUMN_VALUE_FROM_NAME
- 3.21 GET_DATABASE_METADATA
- 3.22 GET_DDL_RECORD_PROPERTIES
- 3.23 @GETENV
- 3.24 GET_ENV_VALUE
- 3.25 GET_ERROR_INFO
- 3.26 GET_GMT_TIMESTAMP
- 3.27 GET_OBJECT_NAME
- 3.28 GET_OBJECT_NAME_ONLY
- 3.29 GET_OPERATION_TYPE
- 3.30 GET_POSITION
- 3.31 GET_RECORD_BUFFER
- 3.32 GET_RECORD_LENGTH
- 3.33 GET_RECORD_TYPE
- 3.34 GET_SCHEMA_NAME_ONLY
- 3.35 GET_SESSION_CHARSET
- 3.36 GET_STATISTICS
- 3.37 GET_TABLE_COLUMN_COUNT
- 3.38 GET_TABLE_METADATA
- 3.39 GET_TABLE_NAME
- 3.40 GET_TABLE_NAME_ONLY
- 3.41 GET_TIMESTAMP
- 3.42 GET_TRANSACTION_IND
- 3.43 GET_USER_TOKEN_VALUE
- 3.44 OUTPUT_MESSAGE_TO_REPORT
- 3.45 RESET_USEREXIT_STATS
- 3.46 SET_COLUMN_VALUE_BY_INDEX
- 3.47 SET_COLUMN_VALUE_BY_NAME
- 3.48 SET_OPERATION_TYPE
- 3.49 SET_RECORD_BUFFER
- 3.50 SET_SESSION_CHARSET
- 3.51 SET_TABLE_NAME
-
1
Oracle GoldenGate Parameters
-
Part II Oracle GoldenGate Classic Architecture
- Summary of GLOBALS Parameter
- 4 Summary of Extract Parameters (Classic Architecture)
- 5 Summary of Replicat Parameters
- 6 Collector Parameters
-
7
Manager Parameters
- 7.1 ACCESSRULE
- 7.2 ALLOWOUTPUTDIR
- 7.3 BOOTDELAYMINUTES
- 7.4 CHARSET
- 7.5 CHECKMINUTES
- 7.6 COMMENT | --
- 7.7 DOWNREPORTMINUTES | DOWNREPORTHOURS
- 7.8 DYNAMICPORTLIST
- 7.9 MONITORING_HEARTBEAT_TIMEOUT
- 7.10 LAGCRITICAL
- 7.11 LAGINFO
- 7.12 LAGREPORT
- 7.13 PORT
- 7.14 PURGEDDLHISTORY | PURGEDDLHISTORYALT
- 7.15 PURGEOLDEXTRACTS for Manager
- 7.16 PURGEOLDTASKS
- 7.17 STARTUPVALIDATIONDELAY[CSECS]
- 8 Oracle GoldenGate Programs