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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn > Sent: 5. júlí 2006 09:27 > 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 > > > Fyrirvari/Disclaimer http://www.landsbanki.is/disclaimer