Re: I can't remove JOB

From: cf <news_at_sitinfo.com>
Date: Fri, 18 Apr 2003 16:26:37 +0200
Message-ID: <3ea00b1e$0$29960$4d4eb98e@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:26:37 CDT