Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01940: cannot drop a user that is currently connected
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 05 2006 - 04:35:13 CDT
![]() |
![]() |