Create user x, drop objects, drop user x Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de
-----Ursprüngliche Nachricht----- Von: Vladimir Barac [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:49 An: Multiple recipients of list ORACLE-L Betreff: Drop 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 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: 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).