Database Administration (MOSC)

MOSC Banner

Actions for the DSTv4 update in the 10.2.0.5 patchset [ID 1086400.1]

edited Dec 21, 2010 1:20AM in Database Administration (MOSC) 4 commentsAnswered
 Hi,

We are planning to apply patch set 4(10.2.0.5.0) to our Database running on Oracle 10g R2(10.2.0.3.0) RAC on HP-UX.

Regarding the "Update Oracle Time Zone Definitions" section in Readme of patch 9952230, I went thru "Actions for the DSTv4 update in the 10.2.0.5 patchset [ID 1086400.1]".

I got Version 3 for "SELECT version FROM v$timezone_file;". 

we are coming under section 3Bc:

3Bc) If you have no user TZ (TSTZ and/or TSLTZ) data but you have your own DBMS_SCHEDULER jobs defined, and they are time critical, then we suggest to run utltzpv4.sql

So I executed utltzpv4.sql.

When I "select * from sys.sys_tzuv2_temptab;" I got no rows selected.

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