Nach einem Datenbank-Upgrade sollte ebenfalls die Zeitzonendatei auf den entsprechenden Stand gebracht werden. Bei einem Upgrade auf Oracle 11g R2 kann dieses mit dem folgendem Skript erreicht werden.
conn / as sysdba
set linesize 400
set echo on
startup
select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%' order by property_name;
pause
shutdown immediate
startup upgrade
exec dbms_dst.begin_upgrade(11);
pause
shutdown immediate
startup
select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%' order by property_name;
pause
select owner, table_name, upgrade_in_progress from all_tstz_tables where owner='SYSMAN';
pause
set serveroutput on
declare
num_of_failures number;
begin
dbms_dst.upgrade_database(num_of_failures);
dbms_output.put_line(num_of_failures);
dbms_output.put_line(num_of_failures);
end
;
/
pause
declare
num_of_failures number;
begin
dbms_dst.end_upgrade(num_of_failures);
end
;
/
