1 Oracle GoldenGate Parameters

This chapter contains summaries of the Oracle GoldenGate parameters that control processing, followed by detailed descriptions of each parameter in alphabetical order.

Topics:

• Summary of GLOBALS Parameters
  
• Summary of Extract Parameters
  
• Summary of Replicat Parameters
  
• ABORTDISCARDRECS
  
• ALLOCFILES
  
• ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
  
• ALLOWINVISIBLEINDEXKEYS
  
• ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
  
• ALLOWNONVALIDATEDKEYS
  
• ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
  
• APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
  
• APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
  
• ASCIITOEBCDIC
  
• ASSUMETARGETDEFS
  
• AUTORESTART
  
• AUTOSTART
  
• BATCHSQL
  
• BEGIN
  
• BLOBMEMORY
  
• BINARY_JSON_FORMAT
  
• BR
  
• BULKLOAD
  
• CACHEMGR
  
• CATALOGEXCLUDE
  
• CHARMAP
  
• CHECKPARAMS
  
• CHECKPOINTSECS
  
• CHECKPOINTTABLE
  
• CHUNK_SIZE
  
• CMDTRACE
  
• COLCHARSET
  
• COLMATCH
  
• COMPRESSDELETES | NOCOMPRESSDELETES
  
• COMPRESSUPDATES | NOCOMPRESSUPDATES
  
• COMMIT_SERIALIZATION
  
• COORDSTATINTERVAL
  
• COORDTIMER
  
• CREDENTIALSTORELOCATION
  
• CRYPTOENGINE
  
• CUSEREXIT
  
• DBOPTIONS
  
• DDL
  
• DDLERROR
  
• DDLOPTIONS
  
• DDLSUBST
  
• DDLRULEHINT
  
• DDLTABLE
  
• DECRYPTTRAIL
  
• DEFERAPPLYINTERVAL
  
• DEFSFILE
  
• DIAGLOGRECS
  
• DICTIONARY_CACHE_SIZE
  
• DISCARDFILE | NODISCARDFILE
  
• DISCARDROLLOVER
  
• DYNAMICRESOLUTION
  
• EBCDICTOASCII
  
• ENABLEMONITORING
  
• ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
  
• ENCRYPTTRAIL | NOENCRYPTTRAIL
  
• END
  
• EOFDELAY | EOFDELAYCSECS
  
• EXCLUDEHIDDENCOLUMNS
  
• EXCLUDETAG
  
• EXCLUDEWILDCARDOBJECTSONLY
  
• EXTFILE
  
• EXTRACT
  
• EXTTRAIL
  
• FETCHOPTIONS
  
• FETCHUSERID
  
• FETCHUSERIDALIAS
  
• FILTERDUPS | NOFILTERDUPS
  
• FILEGROUP
  
• FLUSHSECS | FLUSHCSECS
  
• FUNCTIONSTACKSIZE
  
• GETAPPLOPS | IGNOREAPPLOPS
  
• GETDELETES | IGNOREDELETES
  
• GETINSERTS | IGNOREINSERTS
  
• GETREPLICATES | IGNOREREPLICATES
  
• GETTRUNCATES | IGNORETRUNCATES
  
• GETUPDATEAFTERS | IGNOREUPDATEAFTERS
  
• GETUPDATEBEFORES | IGNOREUPDATEBEFORES
  
• GETUPDATES | IGNOREUPDATES
  
• GGSCHEMA
  
• GROUPTRANSOPS
  
• HANDLECOLLISIONS | NOHANDLECOLLISIONS
  
• HAVEUDTWITHNCHAR
  
• HEARTBEATTABLE
  
• INCLUDE
  
• INCLUDETAG
  
• INITIALLOADOPTIONS
  
• INSERTALLRECORDS
  
• INSERTAPPEND | NOINSERTAPPEND
  
• INSERTDELETES | NOINSERTDELETES
  
• INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
  
• INSERTUPDATES | NOINSERTUPDATES
  
• INSERTUPSERTS | NOINSERTUPSERTS
  
• LIST | NOLIST
  
• LOGALLSUPCOLS
  
• LOOK_AHEAD_TRANSACTIONS
  
• LOGOUT_RECV_TIMEOUT
  
• LRSNTIMEDELTA
  
• MACRO
  
• MACROCHAR
  
• MAP for Extract
  
• MAP
  
• MAPALLCOLUMNS| NOMAPALLCOLUMNS
  
• MAP_PARALLELISM
  
• MAPEXCLUDE
  
• MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
  
• MASTERKEYNAME
  
• MAXDISCARDRECS
  
• MAXGROUPS
  
• MAXSQLSTATEMENTS
  
• MAXTRANSOPS
  
• MGRSERVNAME
  
• NAMECCSID
  
• NAMEMATCH parameters
  
• NLS_LENGTH_SEMANTICS
  
• NOCATALOG
  
• NODUPMSGSUPPRESSION
  
• NUMFILES
  
• OBEY
  
• OUTPUTFILEUMASK
  
• OUTPUTFORMAT
  
• OVERRIDEDUPS | NOOVERRIDEDUPS
  
• PARTITION | PARTITIONEXCLUDE
  
• PTKMONITORFREQUENCY
  
• PRESERVETARGETTIMEZONE
  
• PROCEDURE
  
• PURGEOLDEXTRACTS for Extract and Replicat
  
• REPERROR
  
• REPFETCHEDCOLOPTIONS
  
• REPLACEBADCHAR
  
• REPLACEBADNUM
  
• REPLICAT
  
• REPORT
  
• REPORTCOUNT
  
• REPORTROLLOVER
  
• REPOUDPPORT
  
• RESTARTCOLLISIONS | NORESTARTCOLLISIONS
  
• RMTFILE
  
• RMTHOST
  
• RMTHOSTOPTIONS
  
• RMTTRAIL
  
• ROLLOVER
  
• SCHEMAEXCLUDE
  
• SEQUENCE
  
• SESSIONCHARSET
  
• SETENV
  
• SOURCEDB
  
• SOURCECATALOG
  
• SOURCECHARSET
  
• SOURCEDEFS
  
• SOURCEISTABLE
  
• SOURCETIMEZONE
  
• SPACESTONULL | NOSPACESTONULL
  
• SPECIALRUN
  
• SPLIT_TRANS_RECS
  
• SQLDUPERR
  
• SQLEXEC
  
• STATOPTIONS
  
• TABLE | MAP
  
• TABLE for DEFGEN
  
• TABLE for Replicat
  
• TABLEEXCLUDE
  
• TARGETDB
  
• TARGETDEFS
  
• TCPSOURCETIMER | NOTCPSOURCETIMER
  
• TRACE | TRACE2
  
• TRACETABLE | NOTRACETABLE
  
• TRAILBYTEORDER
  
• TRAILCHARSET
  
• TRAILCHARSETASCII
  
• TRAILCHARSETEBCDIC
  
• TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
  
• TRANLOGOPTIONS
  
• TRANSACTIONTIMEOUT
  
• TRANSMEMORY
  
• TRIMSPACES | NOTRIMSPACES
  
• TRIMVARSPACES | NOTRIMVARSPACES
  
• UPDATEDELETES | NOUPDATEDELETES
  
• UPDATEINSERTS | NOUPDATEINSERTS
  
• UPDATERECORDFORMAT
  
• UPREPORTMINUTES | UPREPORTHOURS
  
• USE_TRAILDEFS | NO_USE_TRAILDEFS
  
• USEDEDICATEDCOORDINATIONTHREAD
  
• USEIPV4 | USEIPV6
  
• USERID | NOUSERID
  
• USERIDALIAS
  
• VARWIDTHNCHAR | NOVARWIDTHNCHAR
  
• WALLETLOCATION
  
• WARNLONGTRANS
  
• WARNRATE
  
• WILDCARDRESOLVE
  
• XAGENABLE
  
• Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT