How do I replicate a table with datatype TIMESTAMP WITH LOCAL TIMEZONE?
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;