My Oracle Support Banner

Extract always shows UTC/GMT timestamp in SHOWTRANS output (Doc ID 2732205.1)

Last updated on JANUARY 05, 2021

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Symptoms

Extract always shows UTC/GMT timestamp in SHOWTRANS output.

i.e. extract (both classic & integrated extracts) display timestamp in SHOWTRANS output always in UTC.

SQL> select scn_to_timestamp(13922959159) as timestamp from dual;

TIMESTAMP
---------------------------------------------------------------------------
06-JUL-20 09.29.48.000000000 AM <= PDT

SQL> select dbtimezone from dual;

DBTIME
------
-07:00

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
---------------------------------------------------------------------------
-07:00
+++++

GGSCI (<HOST_NAME> 8> send EADR2PRD showtrans

Sending SHOWTRANS request to EXTRACT EADR2PRD ...

------------------------------------------------------------
XID: 0.57.33.1469812
Items: 0
Extract: EADR2PRD
Redo Thread: 1
Start Time: 2020-07-06T16:29:49.000Z <= UTC
SCN: 3.1038057271 (13922959159)
Redo Seq: 99163
Redo RBA: 1131793424
Status: Running
++++++

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.