Table of Contents
- Title and Copyright Information
- Preface
-
Part I Oracle GoldenGate Common Components
-
1
Oracle GoldenGate Parameters
- 1.1 Summary of Extract Parameters
- 1.2 Summary of Replicat Parameters
- 1.3 ABORTDISCARDRECS
- 1.4 ALLOCFILES
- 1.5 ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
- 1.6 ALLOWINVISIBLEINDEXKEYS
- 1.7 ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
- 1.8 ALLOWNONVALIDATEDKEYS
- 1.9 ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
- 1.10 ALLOWOUTPUTDIR
- 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 BR
- 1.21 BULKLOAD
- 1.22 CACHEMGR
- 1.23 CATALOGEXCLUDE
- 1.24 CHARMAP
- 1.25 CHECKPARAMS
- 1.26 CHECKPOINTSECS
- 1.27 CHECKPOINTTABLE
- 1.28 CHUNK_SIZE
- 1.29 CMDTRACE
- 1.30 COLCHARSET
- 1.31 COLMATCH
- 1.32 COMPRESSDELETES | NOCOMPRESSDELETES
- 1.33 COMPRESSUPDATES | NOCOMPRESSUPDATES
- 1.34 COMMIT_SERIALIZATION
- 1.35 COORDSTATINTERVAL
- 1.36 COORDTIMER
- 1.37 CREDENTIALSTORELOCATION
- 1.38 CRYPTOENGINE
- 1.39 CUSEREXIT
- 1.40 DBOPTIONS
- 1.41 DDL
- 1.42 DDLERROR
- 1.43 DDLOPTIONS
- 1.44 DDLSUBST
- 1.45 DDLRULEHINT
- 1.46 DDLTABLE
- 1.47 DECRYPTTRAIL
- 1.48 DEFERAPPLYINTERVAL
- 1.49 DEFSFILE
- 1.50 DICTIONARY_CACHE_SIZE
- 1.51 DISCARDFILE | NODISCARDFILE
- 1.52 DISCARDROLLOVER
- 1.53 DYNAMICRESOLUTION | NODYNAMICRESOLUTION
- 1.54 EBCDICTOASCII
- 1.55 ENABLEMONITORING
- 1.56 ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
- 1.57 ENCRYPTTRAIL | NOENCRYPTTRAIL
- 1.58 END
- 1.59 EOFDELAY | EOFDELAYCSECS
- 1.60 EXCLUDEHIDDENCOLUMNS
- 1.61 EXCLUDETAG
- 1.62 EXCLUDEWILDCARDOBJECTSONLY
- 1.63 EXTFILE
- 1.64 EXTRACT
- 1.65 EXTTRAIL
- 1.66 FETCHOPTIONS
- 1.67 FETCHUSERID
- 1.68 FETCHUSERIDALIAS
- 1.69 FILTERDUPS | NOFILTERDUPS
- 1.70 FILEGROUP
- 1.71 FLUSHSECS | FLUSHCSECS
- 1.72 FUNCTIONSTACKSIZE
- 1.73 GETAPPLOPS | IGNOREAPPLOPS
- 1.74 GETDELETES | IGNOREDELETES
- 1.75 GETINSERTS | IGNOREINSERTS
- 1.76 GETREPLICATES | IGNOREREPLICATES
- 1.77 GETTRUNCATES | IGNORETRUNCATES
- 1.78 GETUPDATEAFTERS | IGNOREUPDATEAFTERS
- 1.79 GETUPDATEBEFORES | IGNOREUPDATEBEFORES
- 1.80 GETUPDATES | IGNOREUPDATES
- 1.81 GGSCHEMA
- 1.82 GROUPTRANSOPS
- 1.83 HANDLECOLLISIONS | NOHANDLECOLLISIONS
- 1.84 HAVEUDTWITHNCHAR
- 1.85 HEARTBEATTABLE
- 1.86 INCLUDE
- 1.87 INSERTALLRECORDS
- 1.88 INSERTAPPEND | NOINSERTAPPEND
- 1.89 INSERTDELETES | NOINSERTDELETES
- 1.90 INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- 1.91 INSERTUPDATES | NOINSERTUPDATES
- 1.92 INSERTUPSERTS | NOINSERTUPSERTS
- 1.93 LIST | NOLIST
- 1.94 LOBMEMORY
- 1.95 LOGALLSUPCOLS
- 1.96 LOOK_AHEAD_TRANSACTIONS
- 1.97 MACRO
- 1.98 MACROCHAR
- 1.99 MAP for Extract
- 1.100 MAP
- 1.101 MAPALLCOLUMNS| NOMAPALLCOLUMNS
- 1.102 MAP_PARALLELISM
- 1.103 MAPEXCLUDE
- 1.104 MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
- 1.105 MARKERTABLE
- 1.106 MASTERKEYNAME
- 1.107 MAXDISCARDRECS
- 1.108 MAXGROUPS
- 1.109 MAXSQLSTATEMENTS
- 1.110 MAXTRANSOPS
- 1.111 MGRSERVNAME
- 1.112 NAMECCSID
- 1.113 NAMEMATCH parameters
- 1.114 NOCATALOG
- 1.115 NODUPMSGSUPPRESSION
- 1.116 NUMFILES
- 1.117 OBEY
- 1.118 OUTPUTFILEUMASK
- 1.119 OUTPUTFORMAT
- 1.120 OVERRIDEDUPS | NOOVERRIDEDUPS
- 1.121 PARTIALBLOCKRETRYSECS
- 1.122 PTKCAPTUREPROCSTATS
- 1.123 PTKMONITORFREQUENCY
- 1.124 PRESERVETARGETTIMEZONE
- 1.125 PROCEDURE
- 1.126 PURGEOLDEXTRACTS for Extract and Replicat
- 1.127 REPERROR
- 1.128 REPFETCHEDCOLOPTIONS
- 1.129 REPLACEBADCHAR
- 1.130 REPLACEBADNUM
- 1.131 REPLICAT
- 1.132 REPORT
- 1.133 REPORTCOUNT
- 1.134 REPORTROLLOVER
- 1.135 REPOUDPPORT
- 1.136 RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- 1.137 RMTFILE
- 1.138 RMTHOST
- 1.139 RMTHOSTOPTIONS
- 1.140 RMTTASK
- 1.141 RMTTRAIL
- 1.142 ROLLOVER
- 1.143 SCHEMAEXCLUDE
- 1.144 SEQUENCE
- 1.145 SESSIONCHARSET
- 1.146 SETENV
- 1.147 SHOWSYNTAX
- 1.148 SOURCEDB
- 1.149 SOURCECATALOG
- 1.150 SOURCECHARSET
- 1.151 SOURCEDEFS
- 1.152 SOURCEISTABLE
- 1.153 SOURCETIMEZONE
- 1.154 SPACESTONULL | NOSPACESTONULL
- 1.155 SPECIALRUN
- 1.156 SPLIT_TRANS_RECS
- 1.157 SQLDUPERR
- 1.158 SQLEXEC
- 1.159 STATOPTIONS
- 1.160 TABLE | MAP
- 1.161 TABLE for DEFGEN
- 1.162 TABLE for Replicat
- 1.163 TABLEEXCLUDE
- 1.164 TARGETDB
- 1.165 TARGETDEFS
- 1.166 TCPSOURCETIMER | NOTCPSOURCETIMER
- 1.167 TRACE | TRACE2
- 1.168 TRACETABLE | NOTRACETABLE
- 1.169 TRAILBYTEORDER
- 1.170 TRAILCHARSET
- 1.171 TRAILCHARSETASCII
- 1.172 TRAILCHARSETEBCDIC
- 1.173 TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
- 1.174 TRANLOGOPTIONS
- 1.175 TRANSACTIONTIMEOUT
- 1.176 TRANSMEMORY
- 1.177 TRIMSPACES | NOTRIMSPACES
- 1.178 TRIMVARSPACES | NOTRIMVARSPACES
- 1.179 UPDATEDELETES | NOUPDATEDELETES
- 1.180 UPDATEINSERTS | NOUPDATEINSERTS
- 1.181 UPDATERECORDFORMAT
- 1.182 UPREPORTMINUTES | UPREPORTHOURS
- 1.183 USE_TRAILDEFS | NO_USE_TRAILDEFS
- 1.184 USEDEDICATEDCOORDINATIONTHREAD
- 1.185 USEIPV4 | USEIPV6
- 1.186 USERID | NOUSERID
- 1.187 USERIDALIAS
- 1.188 VARWIDTHNCHAR | NOVARWIDTHNCHAR
- 1.189 WALLETLOCATION
- 1.190 WARNLONGTRANS
- 1.191 WARNRATE
- 1.192 WILDCARDRESOLVE
- 1.193 XAGENABLE
- 1.194 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_MARKER_INFO
- 3.28 GET_OBJECT_NAME
- 3.29 GET_OBJECT_NAME_ONLY
- 3.30 GET_OPERATION_TYPE
- 3.31 GET_POSITION
- 3.32 GET_RECORD_BUFFER
- 3.33 GET_RECORD_LENGTH
- 3.34 GET_RECORD_TYPE
- 3.35 GET_SCHEMA_NAME_ONLY
- 3.36 GET_SESSION_CHARSET
- 3.37 GET_STATISTICS
- 3.38 GET_TABLE_COLUMN_COUNT
- 3.39 GET_TABLE_METADATA
- 3.40 GET_TABLE_NAME
- 3.41 GET_TABLE_NAME_ONLY
- 3.42 GET_TIMESTAMP
- 3.43 GET_TRANSACTION_IND
- 3.44 GET_USER_TOKEN_VALUE
- 3.45 OUTPUT_MESSAGE_TO_REPORT
- 3.46 RESET_USEREXIT_STATS
- 3.47 SET_COLUMN_VALUE_BY_INDEX
- 3.48 SET_COLUMN_VALUE_BY_NAME
- 3.49 SET_OPERATION_TYPE
- 3.50 SET_RECORD_BUFFER
- 3.51 SET_SESSION_CHARSET
- 3.52 SET_TABLE_NAME
-
1
Oracle GoldenGate Parameters
-
Part II Oracle GoldenGate Classic Architecture
- 4 Collector Parameters
-
5
Manager Parameters
- 5.1 ACCESSRULE
- 5.2 BOOTDELAYMINUTES
- 5.3 CHARSET
- 5.4 CHECKMINUTES
- 5.5 COMMENT | --
- 5.6 DOWNREPORTMINUTES | DOWNREPORTHOURS
- 5.7 DYNAMICPORTLIST
- 5.8 MONITORING_HEARTBEAT_TIMEOUT
- 5.9 LAGCRITICAL
- 5.10 LAGINFO
- 5.11 LAGREPORT
- 5.12 PORT
- 5.13 PURGEDDLHISTORY | PURGEDDLHISTORYALT
- 5.14 PURGEOLDEXTRACTS for Manager
- 5.15 PURGEOLDTASKS
- 5.16 SOURCEDB
- 5.17 STARTUPVALIDATIONDELAY[CSECS]
- 5.18 THREADOPTIONS
- 5.19 USERIDALIAS
- 6 Oracle GoldenGate Programs