Oracle GoldenGate: Pump (Extract) Sample Parameter File

-- Runcmd: ADD EXTRACT [pump name], EXTTRAILSOURCE [extract trail
-- Path/two character trail id]
-- Runcmd: ADD RMTTRAIL [pump trail path/two character trail id] ,
-- EXTRACT [pump name], Megabytes [n]
-- Name of the Pump process. Limited to 8 charecters.

EXTRACT [Pump name]

-- Oracle environment settings
SETENV (ORACLE_HOME = "[Oracle home path]" )
SETENV (ORACLE_SID="[Oracle sid]")

-- In passthru mode GoldenGate pump process cascades captured data from 
-- source to target without logging in to the source database 
Passthru

-- Remote host and remort manager port to write trail
RMTHOST [Remote hostname], MGRPORT [Target manager port number]

-- Remote trail info
RMTTRAIL [extract trail path/two character trail id]

--Discard file location.
DISCARDFILE [diacard file path/[discard file name.dsc], APPEND Megabytes [n]

-- Use the DISCARDROLLOVER parameter to set a schedule for aging discard --files.
DISCARDROLLOVER AT [hh:mi] on [day of the week]

-- Use the REPORTROLLOVER parameter to force report files to age on a
-- Regular schedule, instead of when a process starts
REPORTROLLOVER AT [hh:mi] on [day of the week]

-- Use the REPORTCOUNT parameter to report a count of transaction
-- Records that Extract or Replicat processed since startup
REPORTCOUNT EVERY [n] HOURS, RATE

-- List of tables
Table [source schema name].[table name];