Database Administration (MOSC)

MOSC Banner

Is time zone data updated during a Data Pump import?

edited Aug 4, 2015 2:37PM in Database Administration (MOSC) 2 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center