Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01940: cannot drop a user that is currently connected

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

From: John Dunn <jdunn_at_sefas.com>
Date: Wed, 5 Jul 2006 10:27:08 +0100
Message-ID: <000801c6a015$30f35a90$3e04050a@johnman> 





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 - 04:27:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US