Re: Schroedingers Job - a job exists but doesn't at the same time.
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Mon, 16 Dec 2013 16:52:56 +0100
Message-ID: <52AF21D8.3020001_at_mgm-tp.com>
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%'
>
Date: Mon, 16 Dec 2013 16:52:56 +0100
Message-ID: <52AF21D8.3020001_at_mgm-tp.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 16 2013 - 16:52:56 CET