RE: Drop snapshot & ORA-03113

From: Johnson, Michael <Michael.Johnson_at_oln-afmc.af.mil>
Date: Wed, 16 Oct 2002 08:54:27 -0800
Message-ID: <F001.004EABFD.20021016085427@fatcity.com>

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: vladob_at_aster.si

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: ListGuru_at_fatcity.com (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: Michael.Johnson_at_oln-afmc.af.mil

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: ListGuru_at_fatcity.com (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). Received on Wed Oct 16 2002 - 11:54:27 CDT