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

Oracle Error Message

ORA-39360: Table string was skipped due to transportable import and TSLTZ issues resulting from time zone mismatch.

Reason for the Error

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

Solution

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