"Source time zone version is NULL" During TTS from 10g to 12c using expdp/impdp
(Doc ID 2793624.1)
Last updated on JANUARY 19, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
;;;
Import: Release 12.1.0.2.0 - Production on Wed Jun 23 16:33:00 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** directory=DIR_XTTS logfile=file_transfer_tts_imp.log
...
Source time zone version is NULL and target time zone version is 4.
Source time zone is +00:00 and target time zone is +02:00.
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Changes
Source Database
SQL> select * from registry$database;
PLATFORM_ID PLATFORM_NAME EDITION
----------- -------------------- --------------------
4 HP-UX IA (64-bit)
Target Database
SQL> select TZ_VERSION from registry$database;
TZ_VERSION
----------
4
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 |