Is time zone data updated during a Data Pump import?
If data is exported from a database using an older time zone file version and imported into a new database using a higher time zone file version, then will time zone data be updated to use the new time zone file after the import?
I am attempting to upgrade a source database, an 11gR2 database using time zone file version 14, to a new, target database, a 12c database using time zone file version 18 using Data Pump. So far, everything is fine but I am unsure how to determine if the time zone data needs to be updated.
Any help would be greatly appreciated.