Database Utilities (MOSC)

MOSC Banner

how can i upgrade timezone in a databse to enbale datapump import?

Hi,

I am trying to make a datapump import from a production database withe DST_PRIMARY_TT_VERSION set to 32 to a dev database with DST_PRIMARY_TT_VERSION set to 26. the import failed because of this lags.

I tried this note Applying the DSTv36 update for the Oracle Database (Doc ID 2767770.1)

but it don't help me to resolve the problem.

When I query the following:

COLUMN property_name FORMAT A30

COLUMN property_value FORMAT A20


SELECT property_name, property_value

FROM  database_properties

WHERE property_name LIKE 'DST_%'

ORDER BY property_name;SQL> SQL> SQL>  2  3  4

PROPERTY_NAME         PROPERTY_VALUE

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