Oracle drop job report ORA-27478

最新推荐文章于 2022-07-12 17:30:56 发布

忽略的爱

最新推荐文章于 2022-07-12 17:30:56 发布

阅读量1k

点赞数

分类专栏： Oracle 文章标签：数据库 oracle Job

本文链接：https://blog.csdn.net/huluedeai/article/details/117975847

版权

当尝试删除Oracle作业时遇到ORA-27478错误。解决方案是设置force选项为TRUE。如果作业正在运行，不设置force会导致删除失败。force选项设为TRUE会尝试停止作业，然后删除；或者先调用STOP_JOB停止作业，再调用DROP_JOB。defer选项设为TRUE则允许作业完成后再删除。错误发生时，commit_semantics参数决定处理方式。示例中展示了使用defer和transactional提交语义删除作业的例子。

摘要由CSDN通过智能技术生成

When execute drop job, Oracle report ORA-27478

dbms_scheduler.drop_job(job_name => 'Test_job');

ERROR at line 1:
ORA-27478: job "ARBOR"."Test_job" is running
ORA-06512: at "SYS.DBMS_ISCHED", line 278
ORA-06512: at "SYS.DBMS_SCHEDULER", line 751
ORA-06512: at line 8

The solution: set the force option to TRUE

dbms_scheduler.drop_job(job_name=> 'Test_job', force => TRUE);

Explaination: If a job is running at the time of the procedure call, the attempt to drop the job fails. You can modify this default behavior by setting either the force or defer option.