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

Oracle Error Message

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

Reason for the Error

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

Solution

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.