????ORACLE 11G ?2??????????????GOLDENGATE ???????????????????????ORACLE ???????????????
???????????趨??????22??????????AIX ????????????CDT ????????TIMEZONE ??CST6CDT??????????
????????????????AIX 6.1 ??б?????????????????????а????????????????????????????????
????Asia/Shanghai??OS????????GOLDENGATE / ORACLE /AIX ????????
??????????????
????1.GOLDENGATE ???е?TRAIL FILE ????????????REPLICATE ABEND
?????????????
????ALTER REPLICAT REP* ?? extseqno xxx ??extrba xxx
????2.ORACLE ?з?????????TIMEZONE ??????????????????????????????仹????
?????????????
????????????????ο???http://space.itpub.net/175005/viewspace-618100
?????????????????TIMESTAMP WITH LOCAL TIME ZONE ?????
????ALTER DATABASE SET TIME_ZONE='+08:00';
????Completed: ALTER DATABASE SET TIME_ZONE='+08:00'
????Wed Oct 09 09:37:10 2013
?????????????
???????????????
????select * from database_properties where property_name = 'DBTIMEZONE';
???????  scheduler default_timezone ??????
9:40:01 SQL> set verify off
9:40:08 SQL> variable v_value varchar2(1000);
9:40:20 SQL> begin
2  dbms_scheduler.get_scheduler_attribute(attribute => 'default_timezone'??value => :v_value);
3  end;
4  /
PL/SQL procedure successfully completed
Executed in 0.016 seconds
v_value
---------
CST6CDT
???????????????TZ CST6CDT
???и????
9:44:12 SQL> BEGIN
2   DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE(
3     ATTRIBUTE => 'default_timezone'??
4     VALUE => 'Asia/Shanghai');
5  END;
6
7  /
PL/SQL procedure successfully completed
Executed in 0.031 seconds
???????С?????????????