Re: Schroedingers Job - a job exists but doesn't at the same time.
- From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Dec 2013 13:15:36 +0100
(Re-sending because I forgot to trim the message text)
Thanks for the pointer.
Unfortunately it's not a standby database (and DocID 1290836.1 does not apply
either)
Regards
Thomas
Niall Litchfield, 16.12.2013 13:01:
> If this is a snapshot standby database then 1551817.1 probably applies.
>
>
> But when I try to create a job with that name using:
>
> execute DBMS_SCHEDULER.create_job(job_name => 'MY_JOBNAME', job_type =>
> 'PLSQL_BLOCK', job_action => 'begin ... end;', enabled => TRUE);
>
> I get the following error: ORA-27477: "MY_USER.MY_JOBNAME" already exists
>
> If I use a different job name (e.g. MY_JOBNAMEX) I can create and drop
> the job without problems.
>
> Does anyone have an idea on where else I could look for an object with
> that name that prevents creating the job?
>
> I am using Oracle 11.2.0.3 on CentOS
>
>
> Thanks in advance
> Thomas
--
//www.freelists.org/webpage/oracle-l
Other related posts:
