Table of Contents
- Title and Copyright Information
- Preface
- 1 Oracle GoldenGate
-
2
Oracle GoldenGate Parameters
- 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
- BATCHSQL
- BEGIN
- BLOBMEMORY
- BINARY_JSON_FORMAT
- BR
- CACHEMGR
- CATALOGEXCLUDE
- CHARMAP
- CHECKPARAMS
- CHECKPOINTSECS
- CHECKPOINTTABLE
- CHUNK_SIZE
- CMDTRACE
- COLCHARSET
- COLMATCH
- COMPRESSDELETES | NOCOMPRESSDELETES
- COMPRESSUPDATES | NOCOMPRESSUPDATES
- COMMIT_SERIALIZATION
- COORDSTATINTERVAL
- COORDTIMER
- CRYPTOENGINE
- CUSEREXIT
- DBOPTIONS
- DDL
- DDLERROR
- DDLOPTIONS
- DDLSUBST
- 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
- FETCHUSERIDALIAS
- FILTERDUPS | NOFILTERDUPS
- FILEGROUP
- FLUSHSECS | FLUSHCSECS
- FUNCTIONSTACKSIZE
- GETDELETES | IGNOREDELETES
- GETINSERTS | IGNOREINSERTS
- 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
- REPERROR
- REPFETCHEDCOLOPTIONS
- REPLACEBADCHAR
- REPLACEBADNUM
- REPLICAT
- REPORT
- REPORTCOUNT
- REPORTROLLOVER
- RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- RMTFILE
- ROLLOVER
- SCHEMAEXCLUDE
- SEQUENCE
- SESSIONCHARSET
- SETENV
- SOURCECATALOG
- SOURCECHARSET
- SOURCEDEFS
- SOURCEISTABLE
- SOURCETIMEZONE
- SPACESTONULL | NOSPACESTONULL
- SPECIALRUN
- SPLIT_TRANS_RECS
- SQLDUPERR
- SQLEXEC
- STATOPTIONS
- TABLE | MAP
- TABLE for DEFGEN
- TABLE for Replicat
- TABLEEXCLUDE
- TARGETDDLNOTIFY | NOTARGETDDLNOTIFY
- TARGETDEFS
- TCPSOURCETIMER | NOTCPSOURCETIMER
- TRACE | TRACE2
- TRAILBYTEORDER
- TRAILCHARSET
- TRAILCHARSETASCII
- TRAILCHARSETEBCDIC
- TRANLOGOPTIONS
- TRANSACTIONTIMEOUT
- TRIMSPACES | NOTRIMSPACES
- TRIMVARSPACES | NOTRIMVARSPACES
- UPDATEDELETES | NOUPDATEDELETES
- UPDATEINSERTS | NOUPDATEINSERTS
- UPDATERECORDFORMAT
- USEDEDICATEDCOORDINATIONTHREAD
- USEIPV4 | USEIPV6
- USERIDALIAS
- VARWIDTHNCHAR | NOVARWIDTHNCHAR
- WARNLONGTRANS
- WARNRATE
- WILDCARDRESOLVE
- Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
-
3
Table and Column Mapping Functions
- Summary of Column-Conversion Functions
- @RANGE
- @AFTER
- @BEFORE
- @BEFOREAFTER
- @BINARY
- @BINTOBASE64
- @BINTOHEX
- @CASE
- @COLSTAT
- @COLTEST
- @COMPUTE
- @DATE
- @DBFUNCTION
- @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
-
4
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
- 5 Oracle GoldenGate Programs