Actions for the DSTv4 update in the 10.2.0.5 patchset [ID 1086400.1]
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.