Tuesday, November 17, 2009

ORA-27477 Creating a scheduler job.

When the name of the job is the same with an object name in the same schema of the creator of the job you get the ORA-27477 %s.%s already exists error in the EM job page.

Change the job name in order not to match an existing schema object name.

1 comment:

  1. execute DBMS_SCHEDULER.drop_job(job_name => 'MY_JOBNAME', force => true);

    ReplyDelete