Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-39361

Source time zone is string and target time zone is string.

Cause

The time zone of the source database is different than the time zone of the target database.


Action

Tables containing TIMESTAMP WITH LOCAL TIME ZONE data cannot be imported with transportable tablespace technology when time zones are different between the export and target databases. All affected tables will be reported during the import job and will not be created. If any are reported, convert the target database to the same time zone as the source or use Oracle Data Pump with conventional data movement to export then import the affected tables.