Re: Schroedingers Job - a job exists but doesn't at the same time.
- From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
- Date: Mon, 16 Dec 2013 12:23:20 +0100
Sayan,
thanks for the answer.
> You need to check what another object exists with this name:
>
> select owner,object_name,object_type
> from dba_objects o
> where object_name='MY_JOBNAME' and owner='MY_USER';
>
I did check ALL_OBJECTS as the current user:
>> select count(*)
>> from all_objects
>> where upper(object_name) = 'MY_JOBNAME';
>> ==> returns 0
If there was any other object with that name that the current user can see, it
should show up.
But even being connected as SYSDBA:
select count(*)
from dba_objects
where upper(object_name) = 'MY_JOBNAME';
==> returns 0
--
//www.freelists.org/webpage/oracle-l
Other related posts:
