 | | | ORA-01940: cannot drop a user that is currently connected | ORA-01940: cannot drop a user that is currently connected 2006-07-05 - By Laimutis Nedzinskas
Back
Once upon a time I had a session hanging w/o entry in v$session.
Somehow I found the process id and killed it from OS.
> __ ____ ____ ____ ____ ____ ____ ____ ____ __
> From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of John Dunn
> Sent: 5. j?l? 2006 09:27
> To: 'oracle-l digest users'
> Subject: ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that is currently connected
>
> ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that is currently connected
>
> I get this error on Oracle 10.2.0.1.0 but cannot see any sessions for the
user.
>
> I have rerun the drop, but now it just hangs.
>
> Anything I can do but bounce the database?
>
> John Dunn
> Product Consultant
> Direct Dial +44 (0) 117 373 6122
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
> Tel: +44(0) 117 373 6114
> Fax: +44 (0) 117 373 6115
>
> www.sefas.com
>
>
>
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>RE: ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that is currently connected</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Once upon a time I had a session
hanging w/o entry in v$session. </FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Somehow I found the process id
and killed it from OS.</FONT>
</P>
<BR>
<P><FONT SIZE=1 FACE="Tahoma">__ ____ ____ ____ ____ ____ ____ ____ ____ __ <
/FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE=
"Tahoma">oracle-l-bounce@(protected) [</FONT><A HREF="mailto:oracle-l-bounce
@(protected)"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:oracle-l
-bounce@(protected)</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B>
<FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma"
>John Dunn</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1
FACE="Tahoma">5. j?l? 2006 09:27</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT
SIZE=1 FACE="Tahoma">'oracle-l digest users'</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject:
</FONT></B> <FONT SIZE=1 FACE="Tahoma">ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that
is currently connected</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that is currently
connected</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I get this error on Oracle</FONT> <FONT SIZE=2
FACE="r_ansi">10.2.0.1.0</FONT><FONT SIZE=2 FACE="Arial"> but cannot see any
sessions for the user. </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have rerun the drop, but now it just hangs.<
/FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Anything I can do but bounce the database?</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">John Dunn</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Product Consultant</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Direct Dial +44 (0) 117 373 6122</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Sefas Innovation Ltd, CityPoint, Temple
Gate, Bristol BS1 6PL, UK.</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Tel: +44(0) 117 373 6114</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Fax: +44 (0) 117 373 6115</FONT>
</P>
<P><A HREF="file://www.sefas.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Courier
New">www.sefas.com</FONT></U></A>
</P>
<BR>
<BR>
<P><SPAN
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Arial"><BR>Fyrirvari
/Disclaimer<BR><A
href="http://www.landsbanki.is/disclaimer"><SPAN
style="COLOR: gray">http://www.landsbanki.is/disclaimer</SPAN></A><o:p></o:p><
/SPAN></P>
</BODY>
</HTML>
|
|
|