https://forums.toadworld.com/t/ora-01882-when-i-want-to-view-records-con-dba-scheduler-jobs-toad-10-6/30001
Hi
I wANT to view records from DBA_SCHEDULER_JOBS but it shows me this error
select * from SYS.DBA_SCHEDULER_JOBS t
*
Error at line 1
ORA-01882: no se ha encontrado la región de la zona horaria %s
Be aware that it is the first time that we are select this table after the upgrade from oracle single db 10205 to oracle rac 11204 (standard ed)
But when I run this query on my SQL*Plus everything is right. I mean, All is ok.
How can I fix this on Toad ???
thank you
From Dell Support web site knowledge base:
Toad for Oracle Knowledge Article 25830
·
Title
ORA-01882 error when viewing Jobs in schema browser (SYS Schema)
·
Description
When accessing Oracle 10g database and logged on as SYS use, when trying to view Jobs in Schema Browser it will give an Ora-Error 01882 error.
·
Cause
Oracle Client Version : 9.0.4.0.1 which is unsupported by oracle with 10G
·
Resolution
To resolve this issue upgrade to a higher Oracle client.
·
Additional Information
Metalink 397766.1
From: chijar [mailto:bounce-chijar@toadworld.com]
Sent: Friday, May 09, 2014 10:35 PM
Subject: [Toad for Oracle - Discussion Forum] ORA-01882 when I Want to view records con DBA_SCHEDULER_JOBS Toad 10.6
ORA-01882 when I Want to view records con DBA_SCHEDULER_JOBS Toad 10.6 2
Thread created by chijar
Hi
I wANT to view records from DBA_SCHEDULER_JOBS but it shows me this error
select * from SYS.DBA_SCHEDULER_JOBS t
Error at line 1
ORA-01882: no se ha encontrado la región de la zona horaria %s
Be aware that it is the first time that we are select this table after the upgrade from oracle single db 10205 to oracle rac 11204 (standard ed)
But when I run this query on my SQL*Plus everything is right. I mean, All is ok.
How can I fix this on Toad ???
thank you
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
