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
We have logged a TAR with Oracle
regarding this type of scenario except
the client in NT and the server is Sun.
They are in the process of reviewing the
trace file we sent. Everyones hunch is
that its a network issue. You should
be able to reproduce it at with with
various type of DDL. (eg.