Oracle dbms_job remove from another schema

By Ravi Karamsetty | June 10, 2016 |

In the following use case, as sysdba I am trying to remove the job that belongs to another user – ‘AMS2000’ that results in error – ORA-23421. As a sysdba, when you try removing job belonging to another user, you will get ORA-23421 SQL> BEGIN DBMS_JOB.remove(4002); 2 END; 3 / BEGIN DBMS_JOB.remove(4002); * ERROR at … Continue reading “Oracle dbms_job remove from another schema”

Read More