
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