RE: Drop snapshot ORA-03113 - part 2
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 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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113 - part 2
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 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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113
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. DROP USER blah;) -Original Message- Sent: Wednesday, October 16, 2002 8:49 AM To: Multiple recipients of list ORACLE-L 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 - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).