Summary of Replicat Parameters

The Replicat process reads data extracted by the Extract process and applies it to target tables or prepares it for use by another application, such as a load utility.

Replicat parameters are listed in the following table.

Parameter	Description
`HAVEUDTWITHNCHAR`	Causes Replicat to connect in UTF-8 to prevent data loss when the record being processed is a user-defined type that has an `NCHAR/NVARCHAR2` attribute.

Replicat parameters: Processing method.

Parameter	Description
`BEGIN`	Specifies a starting point for Replicat processing. Required when `SPECIALRUN` is specified.
`END`	Specifies a stopping point for Replicat processing. Required when using `SPECIALRUN`.
`REPLICAT`	Specifies a Replicat group for online change synchronization.
`SPECIALRUN`	Used for one-time processing that does not require checkpointing from run to run.

Replicat parameters: Selecting, converting, and mapping data.

Parameter	Description
`DBOPTIONS`	Specifies database options. This is a global parameter, applying to all `TABLE` or `MAP` statements in the parameter file. Some `DBOPTIONS` options apply only to Extract or Replicat.
`ALLOWNOOPUPDATES \| NOALLOWNOOPUPDATES`	Controls how Replicat responds to a no-op operation. A no-op operation is one in which there is no effect on the target table.
`APPLYNOOPUPDATES \| NOAPPLYNOOPUPDATES`	Force a no-op update to be applied using all columns in both the `SET` and `WHERE` clauses.
`APPLY_PARALLELISM`	Configures number of appliers. This controls the number of connections in the target database used to apply the changes. The default value is four.
`ASSUMETARGETDEFS`	Assumes that source and target tables have the same column structure.
`INSERTALLRECORDS`	Inserts a new record into the target table for every change operation made to a record.
`INSERTDELETES \| NOINSERTDELETES`	Converts deletes to inserts.
`INSERTMISSINGUPDATES \| NOINSERTMISSINGUPDATES`	Converts an update to an insert when the target row does not exist.
`INSERTUPDATES \| NOINSERTUPDATES`	Converts updates to inserts.
`TABLE \| MAP`	Specifies a relationship between one or more source and target tables and controls column mapping and conversion.
`MAPEXCLUDE`	Excludes source tables from being processed by a wildcard specification supplied in `MAP` statements.
`MAP_PARALLELISM`	Configures the number of mappers. This controls the number of threads used to read the trail file. The minimum value is 1, maximum value is 100 and the default value is 2.
`MAX_PARALLELISM , MIN_PARALLELISM`	`APPLY_PARALLELISM` is auto-tuned. You can set a minimum and maximum value to define the ranges in which the Replicat automatically adjusts its parallelism. There are no defaults. Do not use with `APPLY_PARALLELISM` at the same time.
`PRESERVETARGETTIMEZONE`	Overrides the default Replicat session time zone.
`REPLACEBADNUM`	Specifies a global substitution value for invalid numeric data encountered when mapping number columns.
`SOURCECHARSET`	Controls whether the source character set it converted to the target character set.
`SOURCETIMEZONE`	Specifies the time zone of the source database for Replicat to use as the session time zone.
`SPACESTONULL \| NOSPACESTONULL`	Controls whether or not a target column containing only spaces is converted to `NULL`.
`TABLE for Replicat`	Specifies a table or tables for which event actions are to take place when a row satisfies the given filter criteria.
`TRAILCHARSET`	Specifies the character set of the source data when the trail is of an older version that does not store the source character set, or to override the character set that is stored in the trail.
`UPDATEINSERTS \| NOUPDATEINSERTS`	Converts insert operations to update operations for all `MAP` statements that are specified after it in the parameter file.
`UPDATEDELETES \| NOUPDATEDELETES`	Converts deletes to updates.
`USEDEDICATEDCOORDINATIONTHREAD`	Specifies a dedicated thread for barrier transactions when Replicat is in coordinated mode.

Replicat parameters: Routing data.

Parameter	Description
`EXTFILE`	Defines the name of an extract file on the local system that contains data to be replicated. Used for one-time processing.
`EXTTRAIL`	Defines a trail containing data to be replicated. Used for one-time processing.

Replicat parameters: Error handling and reporting.

Parameter	Description
`HANDLECOLLISIONS \| NOHANDLECOLLISIONS`	Handles errors for duplicate and missing records.
`OVERRIDEDUPS \| NOOVERRIDEDUPS`	Overlays a replicated insert record onto an existing target record whenever a duplicate-record error occurs.
`RESTARTCOLLISIONS \| NORESTARTCOLLISIONS`	Controls whether or not Replicat applies `HANDLECOLLISIONS` logic after Oracle GoldenGate has abended because of a conflict.
`REPERROR`	Determines how Replicat responds to database errors.
`REPFETCHEDCOLOPTIONS`	Determines how Replicat responds to operations for which a fetch from the source database was required.
`SQLDUPERR`	Specifies the database error number that indicates a duplicate record. Use with `OVERRIDEDUPS`.
`WARNRATE`	Determines how often database errors are reported.

Replicat parameters: Tuning.

Parameter	Description
`BATCHSQL`	Increases the throughput of Replicat processing by arranging similar SQL statements into arrays and applying them at an accelerated rate.
`COORDSTATINTERVAL`	The interval at which the coordinator thread sends a request to the apply threads for statistics.
`COORDTIMER`	The amount of time that the coordinator thread waits for the apply threads to start.
`CHUNK_SIZE`	Controls how large a transaction must be for parallel Replicat to consider it as large. When parallel Replicat encounters a transaction larger than this size, it will serialize it, resulting in decreased performance. However, increasing this value will also increase the amount of memory consumed by parallel Replicat.
`COMMIT_SERIALIZATION`	Enables commit FULL serialization mode, which forces transactions to be committed in trail order.
`DEFERAPPLYINTERVAL`	Specifies a length of time for Replicat to wait before applying replicated operations to the target database.
`GROUPTRANSOPS`	Controls the number of records that are grouped into a Replicat transaction.
`INSERTAPPEND \| NOINSERTAPPEND`	Controls whether or not Replicat uses an `APPEND` hint when applying `INSERT` operations to Oracle target tables.
`LOOK_AHEAD_TRANSACTIONS`	Controls how far ahead the Scheduler looks when batching transactions. The default value is 10000.
`MAXDISCARDRECS`	Limits the number of discarded records reported to the discard file.
`MAXSQLSTATEMENTS`	Controls the number of prepared SQL statements that can be used by Replicat.
`MAXTRANSOPS`	Divides large source transactions into smaller ones on the target system.
`NUMFILES`	Controls the initial allocation of memory that is dedicated to storing information about tables to be processed by Oracle GoldenGate.
`SPLIT_TRANS_REC`	Specifies that large transactions should be broken into pieces of specified size and applied in parallel. Dependencies between pieces are still honored. Disabled by default.
`TRANSACTIONTIMEOUT`	Specifies a time interval after which Replicat will commit its open target transaction and roll back any incomplete source transactions that it contains, saving them for when the entire source transaction is ready to be applied.