Valid for
Extract, Replicat
Description
Use SPECIALRUN
for one-time batch processing. SPECIALRUN
tasks process activity that occurs within a time period, such as the changes logged between 8 a.m. and 3 p.m. on a particular date. Checkpoints are not recorded so the process can not be restarted from an intermediate processing point. An Extract SPECIALRUN
process can read from Oracle GoldenGate or TMF audit trails; a Replicat from Oracle GoldenGate trails.
SPECIALRUN for Extract
You can specify EXTTRAILSOURCE
or EXTFILESOURCE
for Extract to read data from Oracle GoldenGate trails rather than TMF audit trails.
SPECIALRUN
has the following dependencies:
When you specify SPECIALRUN
, you must also specify the BEGIN
and END
parameters.
SPECIALRUN
must precede EXTFILE
, RMTFILE
, EXTTRAIL
or RMTTRAIL
entries.
Syntax
SPECIALRUN [, EXTTRAILSOURCE trail_name] [, EXTFILESOURCE trail_file_name]
Examples
SPECIALRUN for Replicat
For Replicat you must specify EXTTRAIL, RMTTRAIL,
EXTFILE
or RMTFILE
with a SPECIALRUN
.
Replicat always uses BEGIN
and END
to determine when to start and stop processing for a SPECIALRUN
. If nothing is entered for BEGIN
, the process will start with the first record. If nothing is entered for END
, the process start time will be used to determine the limit of the records to process.
Syntax
SPECIALRUN
Example
The following is an example of a Replicat parameter file that would be run from a TACL prompt to load records from the file GGSINI
.ECUSTMER
on the target system to the GGSTAR
.TCUSTMER
table on the target. The GGSINI
.ECUSTMER
file was previously loaded to the target by an Extract one-time run.The data definition for GGSSOU
.ECUSTMER
stored in GGSDEF
.ECUSTDEF
is used to map the structure of the source records to the target.
SPECIALRUN END RUNTIME SOURCEDEFS \B.$DATA3.GGSDEF.ECUSTDEF EXTFILE \B.$DATA3.GGSINI.ECUSTMER MAP \A.$DATA1.GGSSOU.ECUSTMER, TARGET \B.$DATA3.GGSTAR.ECUSTMER;