How to fix the Oracle error ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version.?

In this post, you’ll learn more about the Oracle ErrorORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version.

Reason for the Error ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version.

The source database was at a different time zone version than the target database and there were tables in the dumpfile with TIMESTAMP WITH TIME ZONE columns.

How to fix the Error ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version. ?

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 Data Pump without transportable tablespace.