DBA_JOBS shows that there is job associated with phantom refresh group.
Can't remove job because user that owns it does not exist (remember
fromuser/touser).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vladimir Barac
INET: [EMAIL PROTECTED]
Fat City Network
Have you tried execute sys.dbms_ijob.remove(xx);
An undocumented provedure that I picked up on from this list a few weeks ago
John
-Original Message-
Sent: 16 October 2002 17:04
To: Multiple recipients of list ORACLE-L
DBA_JOBS shows that there is job associated with phantom refresh
See if SYS.DBMS_IJOB.REMOVE(job_id) or
SYS.DBMS_IJOB.DROP_USER_JOBS('USERNAME') works
Regards
Naveen
-Original Message-
Sent: Wednesday, October 16, 2002 9:34 PM
To: Multiple recipients of list ORACLE-L
DBA_JOBS shows that there is job associated with phantom refresh group.
Can't