How to fix the Oracle error ORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch.?

In this post, you’ll learn more about the Oracle ErrorORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch.

Reason for the Error ORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch.

The source database is at a different time zone version than the target database and this table contains TIMESTAMP WITH TIME ZONE data.

How to fix the Error ORA-39339: Table string was skipped due to transportable import and TSTZ issues resulting from time zone version mismatch. ?

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

Convert the target database to the same time zone version as the source database or use Oracle Data Pump with conventional data movement to export then import this table.