RE: ORA-01940: cannot drop a user that is currently connected
From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
To: <jdunn@xxxxxxxxx>, "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 5 Jul 2006 07:19:47 -0400
Does the process show up in V$session. (Most people have scripts joining
v$session and v$process to show sessions that will not show sessions because
the show will only show sessions with process and you can miss some in other
states.) Sometime app/web servers constantly relog in after being killed
making it hard to drop the user. In those cases I shutdown /startup
restrict, drop the user then take off the restricted session.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn
Sent: Wednesday, July 05, 2006 5:27 AM
To: 'oracle-l digest users'
Subject: ORA-01940: cannot drop a user that is currently
connected
ORA-01940: 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
