My Oracle Support Banner

"Source time zone version is NULL" During TTS from 10g to 12c using expdp/impdp (Doc ID 2793624.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.