Good day to all
8.1.7.4 Ent. edition on Windows NT4/SP5
I have performed fromuser = X / touser = Y import and (at a first glance)
everything is fine, as it is supposed to be.
But...
I have noticed that there are some snapshots and one refresh group in
database now, that belong to the user X -
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
snapshot ORA-03113
Good day to all
8.1.7.4 Ent. edition on Windows NT4/SP5
I have performed fromuser = X / touser = Y import and (at a first glance)
everything is fine, as it is supposed to be.
But...
I have noticed that there are some snapshots and one refresh group in
database now, that belong
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.