Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Got a ORA-01940 and the user is not connected. Why?

85870Apr 1 2005 — edited Oct 11 2006
Hello.

I am trying to drop an user but Oracle raise an ORA-01940 error, but the user is not connected.
Please, can anyone tell me why can this be possible?

Thanks in advance.


SQL*Plus: Release 9.2.0.1.0 - Production on Vie Abr 1 10:59:56 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Conectado a:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> DROP USER MYUSER CASCADE;
DROP USER MYUSER CASCADE
*
ERROR en línea 1:
ORA-01940: cannot drop a user that is currently connected

SQL> SELECT COUNT(*) FROM V$SESSION WHERE USERNAME='MYUSER'

COUNT(*)
----------
0

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2006
Added on Apr 1 2005
6 comments
8,996 views