$ export ORA_TZFILE=$ORACLE_HOME/oracore/zoneinfo/timezlrg_13.dat
- Import the source table space into the newly created database, for example:
$ impdp userid=\"/ as sysdba\"directory=DATA_PUMP_EXADATA dumpfile=
- Use the 'dbms_dst' package to upgrade the new database timezone to version 14( in this example).
- Note: The default timezone version for 11.2.0.2 is14..
--注意11.2.0.2 的timezone 默认是14.
2.2 解决方法二：升级source db的Timezone
Upgrade the thesource database Time Zone File and Timestamp with Time Zone Data (TSTZ) to thesame version as the target database version and redo the export.
For the steps todo this upgrade see the "Oracle Database Globalization Support Guide,11gRelease 2 (11.2)" steps under "Upgrading the Time Zone File andTimestamp with Time Zone Data" here:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch4datetime.htm#CACFFHCJ
TSLTZ (TIMESTAMP WITH LOCAL TIME ZONE) dataand DST updates [ID 756454.1]
How To Upgrade The Timezone File Older ThanVersion 11 Using DBMS_DST Package [ID 944122.1]
Updating the RDBMS DST version in 11gR2(11.2.0.1 and up) using DBMS_DST [ID 977512.1]
Actions For DST Updates When Upgrading ToOr Applying The 11.2.0.3 Patchset [ID 1358166.1]
Actions For DST Updates When Upgrading ToOr Applying The 11.2.0.2 Patchset [ID 1201253.1]
Actions For DST Updates When Upgrading To11.2.0.1 Base Release [ID 815679.1]
官网上提到的方法是对于oracle 8i,9i,10g的time zone 升级到11g的方法，基本是运行utltzver.sql脚本，或对于11.2.0.1到11.2.0.3则是直接升级DB.
我这里也直接升级DB，不采用其他的操作了。
这个问题引出的表空间传输的注意事项：
TTS 要求source 和 Target 数据库版本一致，否则就出出现Time zone 的问题，导致impdp 无法成功进行。