1.60 END
Valid For
Replicat
Description
Use the END
parameter to terminate Replicat when it encounters the first record in the data source whose timestamp is the specified point in time.
You can only
use END
with the SPECIALRUN
parameter. This
parameter allows you to post data as a point-in-time snapshot, rather than
continuously updating the target tables.
Without END
, the process runs continuously until:
-
the end of the trail is reached, at which point it will stop gracefully.
-
manually terminated from the command shell.
Default
Continuous processing
Syntax
END {date [time] | RUNTIME}
-
date [time]
-
Causes Replicat to terminate when it reaches a record in the data source whose timestamp exceeds the one that is specified with this parameter.
Valid values:
-
date
is a date in the format ofyyyy-mm-dd
. -
time
is the time in the format ofhh:mi[:ss[.cccccc]]
based on a 24-hour clock.
-
-
RUNTIME
-
Causes Replicat to terminate when it reaches a record in the data source whose timestamp exceeds the current date and clock time. All unprocessed records with timestamps up to this point in time are processed. One advantage of using
RUNTIME
is that you do not have to alter the parameter file to change dates and times from run to run. Instead, you can control the process start time within your batch programming.
Parent topic: Oracle GoldenGate Parameters