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 16:52:56 +0100

Sayan Sergeevich Malakshinov, 16.12.2013 14:44:
> 
> May be you have a dropped object (with type#=10) which isn't cleaned up yet 
> by SMON?
> 
> select * from sys.obj$ where type#=10 and upper(name) like '%MY_JOBNAME%'
> 

Thanks, that indeed returns one row. 

So how do I get rid of this object then? 

Thomas

--
//www.freelists.org/webpage/oracle-l

References:
- Schroedingers Job - a job exists but doesn't at the same time.
  - From: Thomas Kellerer

Other related posts:

» Schroedingers Job - a job exists but doesn't at the same time.- Thomas Kellerer
» RE: Schroedingers Job - a job exists but doesn't at the same time.- Sayan Sergeevich Malakshinov
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Thomas Kellerer
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Howard Latham
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Niall Litchfield
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Thomas Kellerer
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Thomas Kellerer
» Re: Schroedingers Job - a job exists but doesn't at the same time.- Mohamed Houri
» Re: Schroedingers Job - a job exists but doesn't at the same time. - Thomas Kellerer