3.163 SOURCETIMEZONE

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