Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I can't remove JOB
I have create a user A Thus I could remove the job.
Thanks.
Christophe.
"cf" <news_at_sitinfo.com> a écrit dans le message de news:
3ea00b1e$0$29960$4d4eb98e_at_read.news.fr.uu.net...
> I haven't user A in my DB.
>
> select * from all_users order by username
>
> Return much of user, but not user A.
>
> Regards.
> Christophe.
>
>
> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> a écrit dans le message de
> news: m93u9vklhumq99d5ld5942qvcca26hmpp1_at_4ax.com...
> > On Thu, 17 Apr 2003 15:02:51 +0200, "cf" <news_at_sitinfo.com> wrote:
> >
> > >Hello,
> > >
> > >I use oracle 9iR2
> > >After import fromuser=A touser=B
> > >A job with schema_user=A exist (I haven't user A in my new database)
> > >When i try to remove it, an error occur.
> > >
> > >select job, log_user, priv_user, schema_user, what
> > >from dba_jobs
> > >where upper(what) like 'PR_X%'
> > >/
> > > JOB LOG_USER PRIV_USER SCHEMA_USER
> > >WHAT
> >
> ----------- -------------- -----------
> > >-------- ------------
> > > 24 A A
> > >A pr_X;
> > >
> > >exec dmbs_job.remove(24)
> > >
> > >ORA-23421: job number 24 is not a job in the job queue
> > >ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
> > >ORA-06512: at "SYS.DBMS_IJOB", line 529
> > >ORA-06512: at "SYS.DBMS_JOB", line 171
> > >ORA-06512: at line 1
> > >
> > >How can I remove this phantom job ?
> > >
> > >Thanks in advance,
> > >Christophe.
> > >
> > >
> > >
> >
> >
> > Only the job owner can remove a job
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Fri Apr 18 2003 - 09:35:44 CDT