RE: ORA-01940: cannot drop a user that is currently connected

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 5 Jul 2006 07:19:47 -0400
Message-ID: <50938E6468CFED40AE0FD7A507D96D340207DA30@EXCHSERV2.Limited.brands.com>

 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 05 2006 - 06:19:47 CDT