ORA-01882: timezone region %s not found
I got this error while running
select * from dba_scheduler_jobs;
The error message itself turns out not very informative.
01882, 00000, "timezone region %s not found"
// *Cause: The specified region name was not found.
// *Action: Please contact Oracle Customer Support.
A little research on metalink help solved the problem. Metalink has a Doc specifically explain how to fix this error. In short, the error is because there are 7 timezone region IDs changed from version 3 and above. If you have old Timezone data from Version 2 that using one of these IDs the error raises.
The Doc provided a convenience script to fix the problem. After running the script problem gone. For more information check,
Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade
Doc ID: Note:414590.1
2 comments:
Thanks. This has been a niggling problem for quite some time for me. The note pointed to the solution for the client, which was exactly what me and my customers were looking for. Appreciate your sharing this post with us the people.
- Rocker
try to use your query without/formation the columns like START_DATE which has the data type
"TIMESTAMP(6) WITH TIME ZONE"
for e.g.,
select owner, job_name, job_action from dba_scheduler_jobs;
Thanks,
Fazarudeen
Post a Comment