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

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

Oracle Error Description

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

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

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.

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

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

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.