Valid For
Replicat
Description
Use the SOURCETIMEZONE
parameter to specify the time zone of the source database. Use this parameter for one of the following purposes:
To override the source time zone that is stored in the trail. By default, Replicat sets its session to the specified time zone, in both region ID and offset value. This option applies to Oracle GoldenGate versions 12.1.2 or later, where the source time zone is written to the trail by Extract. Replicat will set its session to the specified time zone.
To supply the time zone of the source database when the trail is written by an Extract version that is older than 12.1.2. In these versions, Extract does not write the source time zone to the trail, so it must be supplied by this parameter. Replicat will set its session to the specified time zone.
To disable the default use of the source time zone by Replicat, use the PRESERVETARGETTIMEZONE
parameter in the Replicat parameter file. See PRESERVETARGETTIMEZONE for more information.
Default
None
Syntax
SOURCETIMEZONE time_zone
time_zone
The time zone of the source database as output by the database for DATE
, TIME
and TIMESTAMP
data types. It can be specified in the following ways.
As a region ID that is valid in the IANA Time Zone Database (tz database). (A region ID is also known as an Olson time zone ID). An adjustment for Daylight Saving Time can be performed by the target database, if supported.
As an offset from UTC.
Examples
The following examples show different ways to specify SOURCETIMEZONE
.
These examples specify a region ID.
SOURCETIMEZONE America/New_York SOURCETIMEZONE US/Pacific SOURCETIMEZONE Japan SOURCETIMEZONE UTC SOURCETIMEZONE Pacific/Guam
These examples specify an offset from UTC.
SOURCETIMEZONE +09:00 SOURCETIMEZONE -04:30