Карта сайта Интеллектуальная поисковая системаДобавить свою ссылку по ключевому запросуПоисковая система v3.kz поможет ускорить индексацию вашего сайта выводит в Топ |
|
ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 124 ORA-06512: at "SYS.DBMS_SCHEDULER", line 376 ORA-06512: at line 2 27486. begin DBMS_SCHEDULER.CREATE_JOB (. Wow, I found the problem... "myJob" was an existing package object in the database. Im guessing my "insufficient privileges" were to replace the package object with a job object. ORA-27486: insufficient privileges ORA-06512: at “SYS.DBMS_ISCHED”, line 5 ORA-06512: at “SYS.DBMS_SCHEDULER”, line 30. The Cause. You don’t have appropriate permissions to create jobs in this way. ...DEFAULT_JOB_CLASS, 9 auto_drop => FALSE, 10 enabled => TRUE 11 ); 12* end; SQL> / begin * ERROR at line 1: ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED" ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 99 ORA-06512: at "SYS.DBMS_SCHEDULER", line 262 ORA-06512: at line 2. exec DBMS_SCHEDULER.create_job(... ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 99 ORA-06512: at Error starting at line 1 in command: exec dbms_scheduler.create_job_class(TEST_CLASS) Error report: ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line. Ни удалить ( exec dbms_scheduler.drop_job ), ни остановить ( DBMS_SCHEDULER.STOP_JOB ) не удается. ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 2751 ORA-06512: at "SYS.DBMS_SCHEDULER", line 1794 ORA-06512: at line 2. This happens even if you’re trying to run the job as sys as sysdba. Информация взята v3.kz |
загрузка...
|