How to fix the Oracle error ORA-39359: Source time zone version is string and target time zone version is string.?

In this post, you’ll learn more about the Oracle ErrorORA-39359: Source time zone version is string and target time zone version is string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39359: Source time zone version is string and target time zone version is string.

Reason for the Error ORA-39359: Source time zone version is string and target time zone version is string.

The time zone version of the source database is not the same as the time zone version of the target database.

How to fix the Error ORA-39359: Source time zone version is string and target time zone version is string. ?

You can fix this error in Oracle by following the below steps

Tables containing TIMESTAMP WITH TIME ZONE data cannot be imported with transportable tablespace technology when time zone versions are different between the export and target databases. All affected tables will be reported during the import job and will not be created. If any are reported, convert the target database to the same time zone version as the source or use Oracle Data Pump with conventional data movement to export then import the affected tables.