Table of Contents
- Title and Copyright Information
- Preface
-
Part I Oracle GoldenGate Common Components
-
1
Oracle GoldenGate Parameters
- Summary of Extract Parameters
- Summary of Replicat Parameters
- ABORTDISCARDRECS
- ALLOCFILES
- ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
- ALLOWINVISIBLEINDEXKEYS
- ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
- ALLOWNONVALIDATEDKEYS
- ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
- ALLOWOUTPUTDIR
- APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
- APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
- ASCIITOEBCDIC
- ASSUMETARGETDEFS
- AUTORESTART
- AUTOSTART
- BATCHSQL
- BEGIN
- BLOBMEMORY
- 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
- DICTIONARY_CACHE_SIZE
- DISCARDFILE | NODISCARDFILE
- DISCARDROLLOVER
- DYNAMICRESOLUTION | NODYNAMICRESOLUTION
- 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
- INSERTALLRECORDS
- INSERTAPPEND | NOINSERTAPPEND
- INSERTDELETES | NOINSERTDELETES
- INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- INSERTUPDATES | NOINSERTUPDATES
- INSERTUPSERTS | NOINSERTUPSERTS
- LIST | NOLIST
- LOBMEMORY
- LOGALLSUPCOLS
- LOOK_AHEAD_TRANSACTIONS
- MACRO
- MACROCHAR
- MAP for Extract
- MAP
- MAPALLCOLUMNS| NOMAPALLCOLUMNS
- MAP_PARALLELISM
- MAPEXCLUDE
- MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
- MARKERTABLE
- MASTERKEYNAME
- MAXDISCARDRECS
- MAXGROUPS
- MAXSQLSTATEMENTS
- MAXTRANSOPS
- MGRSERVNAME
- NAMECCSID
- NAMEMATCH parameters
- NOCATALOG
- NODUPMSGSUPPRESSION
- NUMFILES
- OBEY
- ODBCTRACE
- OUTPUTFILEUMASK
- OUTPUTFORMAT
- OVERRIDEDUPS | NOOVERRIDEDUPS
- PARTIALBLOCKRETRYSECS
- PTKMONITORFREQUENCY
- PTKOSMONITORFREQUENCY
- PRESERVETARGETTIMEZONE
- PROCEDURE
- PURGEOLDEXTRACTS for Extract and Replicat
- REPERROR
- REPFETCHEDCOLOPTIONS
- REPLACEBADCHAR
- REPLACEBADNUM
- REPLICAT
- REPORT
- REPORTCOUNT
- REPORTROLLOVER
- REPOUDPPORT
- RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- RMTFILE
- RMTHOST
- RMTHOSTOPTIONS
- RMTTASK
- RMTTRAIL
- ROLLOVER
- SCHEMAEXCLUDE
- SEQUENCE
- SESSIONCHARSET
- SETENV
- SHOWSYNTAX
- 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
-
2
Column Conversion Functions
- Summary of Column-Conversion Functions
- @RANGE
- @AFTER
- @BEFORE
- @BEFOREAFTER
- @BINARY
- @BINTOBASE64
- @BINTOHEX
- @CASE
- @COLSTAT
- @COLTEST
- @COMPUTE
- @DATE
- @DATEDIFF
- @DATENOW
- @DDL
- @EVAL
- @GETENV
- @GETVAL
- @HEXTOBIN
- @HIGHVAL | LOWVAL
- @IF
- @NUMBIN
- @NUMSTR
- @OGG_SHA1
- @STRCAT
- @STRCMP
- @STRCMPNULL
- @STREQ
- @STREQNULL
- @STREXT
- @STRFIND
- @STRLEN
- @STRLTRIM
- @STRNCAT
- @STRNCMP
- @STRNUM
- @STRRTRIM
- @STRSUB
- @STRTRIM
- @STRUP
- @TOKEN
- @VALONEOF
-
3
User Exit Functions
- Summary of User Exit Functions
- Calling a User Exit
- Using EXIT_CALL_TYPE
- Using EXIT_CALL_RESULT
- Using EXIT_PARAMS
- Using ERCALLBACK
- Function Codes
- COMPRESS_RECORD
- DECOMPRESS_RECORD
- GET_BASE_OBJECT_NAME
- GET_BASE_OBJECT_NAME_ONLY
- GET_BASE_SCHEMA_NAME_ONLY
- GET_BEFORE_AFTER_IND
- GET_CATALOG_NAME_ONLY
- GET_COL_METADATA_FROM_INDEX
- GET_COL_METADATA_FROM_NAME
- GET_COLUMN_INDEX_FROM_NAME
- GET_COLUMN_NAME_FROM_INDEX
- GET_COLUMN_VALUE_FROM_INDEX
- GET_COLUMN_VALUE_FROM_NAME
- GET_DATABASE_METADATA
- GET_DDL_RECORD_PROPERTIES
- @GETENV
- GET_ENV_VALUE
- GET_ERROR_INFO
- GET_GMT_TIMESTAMP
- GET_MARKER_INFO
- GET_OBJECT_NAME
- GET_OBJECT_NAME_ONLY
- GET_OPERATION_TYPE
- GET_POSITION
- GET_RECORD_BUFFER
- GET_RECORD_LENGTH
- GET_RECORD_TYPE
- GET_SCHEMA_NAME_ONLY
- GET_SESSION_CHARSET
- GET_STATISTICS
- GET_TABLE_COLUMN_COUNT
- GET_TABLE_METADATA
- GET_TABLE_NAME
- GET_TABLE_NAME_ONLY
- GET_TIMESTAMP
- GET_TRANSACTION_IND
- GET_USER_TOKEN_VALUE
- OUTPUT_MESSAGE_TO_REPORT
- RESET_USEREXIT_STATS
- SET_COLUMN_VALUE_BY_INDEX
- SET_COLUMN_VALUE_BY_NAME
- SET_OPERATION_TYPE
- SET_RECORD_BUFFER
- SET_SESSION_CHARSET
- SET_TABLE_NAME
-
1
Oracle GoldenGate Parameters
-
Part II Oracle GoldenGate Classic Architecture
- 4 Collector Parameters
-
5
Manager Parameters
- ACCESSRULE
- BOOTDELAYMINUTES
- CHARSET
- CHECKMINUTES
- COMMENT | --
- DOWNREPORTMINUTES | DOWNREPORTHOURS
- DYNAMICPORTLIST
- MONITORING_HEARTBEAT_TIMEOUT
- LAGCRITICAL
- LAGINFO
- LAGREPORT
- PORT
- PURGEDDLHISTORY | PURGEDDLHISTORYALT
- PURGEMARKERHISTORY
- PURGEOLDEXTRACTS for Manager
- PURGEOLDTASKS
- SOURCEDB
- STARTUPVALIDATIONDELAY[CSECS]
- THREADOPTIONS
- USERIDALIAS
- 6 Oracle GoldenGate Programs