RMTTASK

Valid For

Extract

Description

Use the RMTTASK parameter for an initial-load Extract to initiate a Replicat processing task during an Oracle GoldenGate direct load or a direct bulk load to SQL*Loader. RMTTASK directs Extract to communicate directly with Replicat over TCP/IP and bypasses the use of a Collector process or trail storage. RMTTASK also directs Extract to request that Manager start Replicat automatically, and then stop Replicat when the run is finished. Tasks do not use checkpoints.

Dependent parameters are as follows:

  • A RMTHOST statement must follow each RMTTASK statement in the initial-load Extract parameter file.

  • EXTRACT must be used in the initial-load Extract parameter file.

  • REPLICAT must be used in the initial-load Replicat parameter file.

  • SOURCEISTABLE must be used in the ADD EXTRACT command.

  • SPECIALRUN must be used in the ADD REPLICAT command.

RMTTASK does not support encryption of any kind. To use encryption, you can use the initial-load method that writes data to a file, which is read by Replicat to load the data.

RMTTASK does not support tables that have columns that contain LOBs, LONGs, user-defined types (UDT), or any other large data type that is greater than 4k in size.

When using RMTTASK, do not start Replicat with the START REPLICAT command. Replicat is started automatically during the task.

See the Administering Oracle GoldenGate for Windows and UNIX for more information about performing initial data loads.

Default

None

Syntax

RMTTASK REPLICAT, GROUP group_name
[FORMAT RELEASE major.minor]
GROUP group_name

The group name of the Initial Load Replicat on the target system.

FORMAT RELEASE major.minor

Specifies the metadata format of the data that is sent by Extract to Replicat. The metadata tells Replicat whether the data records are of a version that it supports. The metadata format depends on the version of the Oracle GoldenGate process. Older Oracle GoldenGate versions contain different metadata than newer ones.

  • FORMAT is a required keyword.

  • RELEASE specifies an Oracle GoldenGate release version. major is the major version number, and minor is the minor version number. The X.x must reflect a current or earlier, generally available (GA) release of Oracle GoldenGate. Valid values are 9.0 through the current Oracle GoldenGate X.x version number, for example 11.2 or 12.1. (If you use an Oracle GoldenGate version that is earlier than 9.0, specify either 9.0 or 9.5.)

    The release version is programmatically mapped back to an appropriate internal compatibility level. The default is the current version of the process that writes to this trail. Note that RELEASE versions earlier than 12.1 do not support three-part object names.

There is a dependency between FORMAT and the RECOVERYOPTIONS parameter. When RECOVERYOPTIONS is set to APPENDMODE, FORMAT must be set to RELEASE 10.0 or greater. When RECOVERYOPTIONS is set to OVERWRITEMODE, FORMAT must be set to RELEASE 9.5 or less.

See Administering Oracle GoldenGate for Windows and UNIX for more information about initial loads.

Example

RMTTASK REPLICAT, GROUP initrep, FORMAT RELEASE 10.0