TIMESTAMP WITH LOCAL TIME ZONE Restrictions

If a table is moved using a transportable mode (transportable table, transportable tablespace, or full transportable), and the following conditions exist, then a warning is issued and the table is not created:

  • The source and target databases have different database time zones

  • The table contains TIMESTAMP WITH LOCAL TIME ZONE data types

To successfully move a table that was not created because of these conditions, use a non-transportable export and import mode.