GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How do I replicate a table with datatype TIMESTAMP WITH LOCAL TIMEZONE?

edited Apr 13, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hello,

I am using Oracle Goldengate 11.2.1.0.4 and my replication of a table with a column of type "TIMESTAMP WITH LOCAL TIMEZONE" always ends up off by the timezone offset on the replicated site.  For example ...

Update statement on "from" site ...

    update fort_h_sem_q1.STP_SYSTEM_STATUS set SYSTEM_STARTED = reload_date where  sem_id= 'AD1QA101';

   

select sem_id, RELOAD_DATE, SYSTEM_STARTED from fort_h_sem_q1.STP_SYSTEM_STATUS where  sem_id= 'AD1QA101';

SEM_ID   RELOAD_DATE                     SYSTEM_STARTED
-------- ------------------------------- --------------------------------
AD1QA101 26-MAR-14 04.24.19.943000 PM    26-MAR-14 04.24.19.943000 PM

COMMIT;

SQL> select dbtimezone,sessiontimezone from dual;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center